viewvc.cgi/sysplogd/report.sql

select
        count(ip),
        ip
from log
group by ip
order by count(ip) desc
limit 10
;

select
        count(program),
        program
from log
group by program
order by count(program) desc
limit 10
;

select
        count(facility),
        facilities.name
from log
full join facilities on facilities.id = log.facility
group by program,facilities.name
order by count(facility) desc
limit 10
;

select * from log order by id desc limit 5 ;
1	dpavlin	7	select
2			count(ip),
3			ip
4			from log
5			group by ip
6			order by count(ip) desc
7			limit 10
8			;
9	dpavlin	4
10	dpavlin	7	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 ;