Skip to main content
rpetty
rpetty
New Member
August 8, 2015
Question

Report packets per firewall policy

  • August 8, 2015
  • 1 reply
  • 2392 views

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.

1 reply

AtiT
AtiT
New Member
August 10, 2015

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

Terms & ConditionsAccessibility statement