Report packets per firewall policy

[rpetty]

I have over 100 60D FortiGates in remote offices that all have a cookie cutter firewall policies.  I am wanting to create a report to show the number of packets per policy.  Then also use this report show a pie graph to show the number allowed vs denied packets.

[AtiT]

Hello,

Try the dataset for traffic log:

SELECT `policyid`, SUM(COALESCE(`sentpkt`,0)+COALESCE(`rcvdpkt`,0)) AS total_packets FROM $log WHERE $filter AND logid_to_int(logid) NOT IN (4, 7, 14) AND `action`!='deny' GROUP BY `policyid` HAVING SUM(COALESCE(`sentpkt`,0)+COALESCE(`rcvdpkt`,0))>=0 ORDER BY total_packets DESC