Toplam trafik :
select $hour_of_day as hourstamp, sum(sent+rcvd)/1024 as volume from $log where $filter group by hourstamp order by hourstamp
Trafik Top 10 :
select src, sum(sent+rcvd) as volume from $log where $filter and src is not null group by src having sum(sent+rcvd)>0 order by volume desc limit 10
En Çok Girilen Siteler :
select hostname, Count(hostname) as volume from $log where $filter and status=’detected’ group by hostname having Count(hostname)>0 order by volume desc limit 10
İnternet Kullanımı:
select itime,sum(sent+rcvd) as toplam from $log where $filter group by itime having sum(sent+rcvd)>0 order by toplam desc limit 10
3,606 total views, 1 views today
