Advertisement
RazZziel

Untitled

Sep 30th, 2017
414
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.10 KB | None | 0 0
  1. 12:00:57 ~$ h-mysql Warner-3Server -e "select hour(time(ev_dateTime)) as Hora, te_name as Terminal, count(*) as 'Accesos sin validación' from event inner join terminal on ev_te_id = te_id where date(ev_dateTime) = date(now()) and ev_code=61 group by ev_te_id, hour(time(ev_dateTime)) order by hour(time(ev_dateTime)), te_name"
  2. * 210-898-206 DEINTA-Warner-3Server 25.37.67.138
  3. +------+-----------------------+-------------------------+
  4. | Hora | Terminal | Accesos sin validación |
  5. +------+-----------------------+-------------------------+
  6. | 0 | Controladora via 1 | 2 |
  7. | 3 | Controladora via 1 | 2 |
  8. | 4 | Controladora via 1 | 2 |
  9. | 7 | Controladora via 1 | 3 |
  10. | 8 | Controladora via 1 | 1 |
  11. | 10 | Controladora via 1 | 2 |
  12. | 10 | Controladora via 2 | 2 |
  13. | 10 | Controladora via 7 | 1 |
  14. | 11 | Controladora via 2 | 36 |
  15. | 11 | Controladora via 3 | 38 |
  16. | 11 | Controladora via 4 | 36 |
  17. | 11 | Controladora via 5 | 39 |
  18. | 11 | Controladora via 6 | 34 |
  19. | 11 | Controladora via 7 | 36 |
  20. | 11 | Controladora via 8 | 27 |
  21. | 11 | Controladora via 9 | 42 |
  22. | 11 | Entrada Zona Cubierta | 1 |
  23. | 12 | Controladora via 2 | 4 |
  24. | 12 | Controladora via 3 | 1 |
  25. | 12 | Controladora via 4 | 1 |
  26. | 12 | Controladora via 5 | 1 |
  27. | 12 | Controladora via 6 | 3 |
  28. | 12 | Controladora via 7 | 3 |
  29. | 12 | Controladora via 8 | 2 |
  30. | 12 | Controladora via 9 | 4 |
  31. +------+-----------------------+-------------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement