FortiGate Next Generation Firewall utilizes purpose-built security processors and threat intelligence security services from FortiGuard labs to deliver top-rated protection and high performance, including encrypted traffic.
This article describes how to export VIP, address, services, ippool objects into Excel or CSV format. At this time, there is no built-in way to export objects into CSV or Excel format.
This article provides a way with an Excel formula to extract values of interest. In the attached spreadsheet, an example is provided to extract VIP objects based on the config file, it is possible to use the same techniques for other objects such as an address, service, ippool, etc.
Scope
FortiGate.
Solution
In the attached spreadsheet, VIP is used as an example and it is desired to extract all VIP objects and make an Excel file.
As can be seen from the Excel file attached, follow the steps below:
Copy the config for the VIP section to Column A, this serves the original source worked from.
Copy the same config again into Column B, for this column, and remove all the unwanted words such as 'edit', 'set', 'mappedip', 'extip', 'extintf', and quote " itself (replace them with NULL).
In Cell from C2 to F2, write the row # that matches the value of interest.
Use the Excel function 'indirect' to retrieve the value needed.
In this example attached, cells A2 to A20 come from the config file as source data, and cells G1 to J4 are the final result needed.
