Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 11:48:27 ~$ 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"
- * 210-898-206 DEINTA-Warner-3Server 25.37.67.138
- +------+-----------------------+---------+
- | Hora | Terminal | Accesos |
- +------+-----------------------+---------+
- | 10 | 3Checkout en caja 1 | 1 |
- | 10 | Controladora via 1 | 1 |
- | 10 | Entrada Zona Cubierta | 25 |
- | 10 | Warner-ATM1-via_2 | 25 |
- | 10 | Warner-ATM2-via_3 | 35 |
- | 10 | Warner-ATM3-via_4 | 24 |
- | 10 | Warner-ATM4-via_5 | 32 |
- | 10 | Warner-ATM5-via_6 | 27 |
- | 10 | Warner-ATM6-via_7 | 28 |
- | 10 | Warner-ATM7-via_8 | 25 |
- | 10 | Warner-ATM8-via_9 | 30 |
- | 11 | 3Checkout en caja 1 | 21 |
- | 11 | Controladora via 1 | 1 |
- | 11 | Controladora via 9 | 1 |
- | 11 | Entrada Zona Cubierta | 45 |
- | 11 | Warner-ATM1-via_2 | 55 |
- | 11 | Warner-ATM2-via_3 | 62 |
- | 11 | Warner-ATM3-via_4 | 57 |
- | 11 | Warner-ATM4-via_5 | 54 |
- | 11 | Warner-ATM5-via_6 | 49 |
- | 11 | Warner-ATM6-via_7 | 44 |
- | 11 | Warner-ATM7-via_8 | 49 |
- | 11 | Warner-ATM8-via_9 | 45 |
- +------+-----------------------+---------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement