Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
Shantilal1998
New Contributor III

Export 0 hit count policies in csv.

Hi Guys,

 

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

5 REPLIES 5
srajeswaran
Staff
Staff

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.

Regards,

Suraj

- Have you found a solution? Then give your helper a "Kudos" and mark the solution.

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 

---------------------------
geek
---------------------------
---------------------------geek---------------------------
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.

---------------------------
geek
---------------------------
---------------------------geek---------------------------
Labels
Top Kudoed Authors