Advertisement
RazZziel

Untitled

Sep 30th, 2017
396
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. 11:01:30 ~$ h-mysql Warner-3Server -e "select hour(time(ass_dateTime)) as Hora, te_name as Terminal, count(*) as Accesos from access inner join terminal on ass_acs_te_id = te_id where date(ass_dateTime) = date(now()) and ass_validationResult=1 group by ass_acs_te_id, hour(time(ass_dateTime)) order by hour(time(ass_dateTime)), te_name"
  2. * 210-898-206 DEINTA-Warner-3Server 25.37.67.138
  3. +------+-----------------------+---------+
  4. | Hora | Terminal | Accesos |
  5. +------+-----------------------+---------+
  6. | 10 | 3Checkout en caja 1 | 1 |
  7. | 10 | Controladora via 1 | 1 |
  8. | 10 | Entrada Zona Cubierta | 25 |
  9. | 10 | Warner-ATM1-via_2 | 25 |
  10. | 10 | Warner-ATM2-via_3 | 35 |
  11. | 10 | Warner-ATM3-via_4 | 24 |
  12. | 10 | Warner-ATM4-via_5 | 32 |
  13. | 10 | Warner-ATM5-via_6 | 27 |
  14. | 10 | Warner-ATM6-via_7 | 28 |
  15. | 10 | Warner-ATM7-via_8 | 25 |
  16. | 10 | Warner-ATM8-via_9 | 30 |
  17. | 11 | Entrada Zona Cubierta | 4 |
  18. | 11 | Warner-ATM1-via_2 | 2 |
  19. | 11 | Warner-ATM2-via_3 | 2 |
  20. | 11 | Warner-ATM3-via_4 | 3 |
  21. | 11 | Warner-ATM4-via_5 | 2 |
  22. | 11 | Warner-ATM5-via_6 | 1 |
  23. | 11 | Warner-ATM6-via_7 | 2 |
  24. | 11 | Warner-ATM7-via_8 | 2 |
  25. | 11 | Warner-ATM8-via_9 | 3 |
  26. +------+-----------------------+---------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement