Export 0 hit count policies in csv.

[Shantilal1998]

Hi Guys,

I want to export security policies with hit counts/Last-used date from Fortigate in CSV. Kindly suggest.

[srajeswaran]

You may export the policies as suggested in below document.

https://docs.fortinet.com/document/fortigate/7.0.0/new-features/862475/export-firewall-policy-list-t...

Then do a sort/filter using "Bytes" column in excel.

[Shantilal1998]

Hi,

I am using FG 800C and which having 5.6 FortiOS. In this version the export option is not available. And also this is the last version of this product. Any other suggestion

[funkylicious]

Hi,

Take a look at this 

[Shantilal1998]

Hi,

I know this method but want hit count column also in csv and via the script it is not possible as we export the details from the backup.

[funkylicious]

Hello,

You are correct.

A combination of the exported rules and creating another script that runs through all the policy id's would be an option, where your run the command : 

diagnose firewall iprope show 00100004 POLICY_ID

found on seq no in the GUI or from show firewall policy, would give you the hit count.