Parent Directory | Revision Log
make sample report on hosts, programs and facilities
1 | select |
2 | count(ip), |
3 | ip |
4 | from log |
5 | group by ip |
6 | order by count(ip) desc |
7 | limit 10 |
8 | ; |
9 | |
10 | select |
11 | count(program), |
12 | program |
13 | from log |
14 | group by program |
15 | order by count(program) desc |
16 | limit 10 |
17 | ; |
18 | |
19 | select |
20 | count(facility), |
21 | facilities.name |
22 | from log |
23 | full join facilities on facilities.id = log.facility |
24 | group by program,facilities.name |
25 | order by count(facility) desc |
26 | limit 10 |
27 | ; |
28 | |
29 | select * from log order by id desc limit 5 ; |
ViewVC Help | |
Powered by ViewVC 1.1.26 |