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
Nominating a forum post submits a request to create a new Knowledge Article based on the forum post topic. Please ensure your nomination includes a solution within the reply.
Select Forum Responses to become Knowledge Articles!
Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.
User | Count |
---|---|
1720 | |
1093 | |
752 | |
447 | |
234 |
The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.
Copyright 2024 Fortinet, Inc. All Rights Reserved.