I want to export security policies with hit counts/Last-used date from Fortigate in CSV. Kindly suggest.
You may export the policies as suggested in below document.
Then do a sort/filter using "Bytes" column in excel.
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
Take a look at this
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.
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.
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 2023 Fortinet, Inc. All Rights Reserved.