Fortianalyzer SQL Örnekleri

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,791 total views, 1 views today