Skip to main content
JoseOrosco
New Member
October 16, 2015
Question

Custom report not recognizing Filter

  • October 16, 2015
  • 0 replies
  • 3226 views

I have a FAZ 3000D with 5.0.9 and I'm trying to create a report which can give Source IP, Website and bandwidth accumulated during a mentioned time which i will put in the Configuration tab.

 

I created the following dataset adding 2 Variables (test.JPG as screenshot)

 

select user_src, hostname, sum(bandwidth) as bandwidth

from

((select coalesce(nullifna(`user`), ipstr(`srcip`)) as user_src, hostname, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth

from $log-webfilter

group by user_src, hostname

having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by bandwidth desc)) t

group by user_src, hostname order by bandwidth desc

 

Then i created a Chart as It is needed so i can add it to a Report by cloning another one. 

 

I have try added a Filter on the Advanced setting (i.e. source IP) but is not being recognized; the data i'm getting on the report is of all the IPs.

 

Please can you tell me how to get this to work?. Im not sure wether is an issue of the Chart or the Dataset.

 

Thanks a lot

Thought Leadership Security Summit. Outpace New Threats with AI - enhanced defense. Tuesday, Septmeber 15, 8:30 AM - 2:30 PM PT. The Golf Club at Newcastle, WA.
Virtual event | September 2026. SASE summit. The age of autonomous trust. Register here!