Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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"
- * 210-898-206 DEINTA-Warner-3Server 25.37.67.138
- +------+-----------------------+-------------------------+
- | Hora | Terminal | Accesos sin validación |
- +------+-----------------------+-------------------------+
- | 0 | Controladora via 1 | 2 |
- | 3 | Controladora via 1 | 2 |
- | 4 | Controladora via 1 | 2 |
- | 7 | Controladora via 1 | 3 |
- | 8 | Controladora via 1 | 1 |
- | 10 | Controladora via 1 | 2 |
- | 10 | Controladora via 2 | 2 |
- | 10 | Controladora via 7 | 1 |
- | 11 | Controladora via 2 | 36 |
- | 11 | Controladora via 3 | 38 |
- | 11 | Controladora via 4 | 36 |
- | 11 | Controladora via 5 | 39 |
- | 11 | Controladora via 6 | 34 |
- | 11 | Controladora via 7 | 36 |
- | 11 | Controladora via 8 | 27 |
- | 11 | Controladora via 9 | 42 |
- | 11 | Entrada Zona Cubierta | 1 |
- | 12 | Controladora via 2 | 4 |
- | 12 | Controladora via 3 | 1 |
- | 12 | Controladora via 4 | 1 |
- | 12 | Controladora via 5 | 1 |
- | 12 | Controladora via 6 | 3 |
- | 12 | Controladora via 7 | 3 |
- | 12 | Controladora via 8 | 2 |
- | 12 | Controladora via 9 | 4 |
- +------+-----------------------+-------------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement