On This Page
CSV Format for Cleanup Instances
When you select a cleanup type in the cleanup browser and click Export, you are prompted to download a CSV file with the details of the instances of the selected cleanup for all of the selected devices. The filename includes cleanup type, and the date and time of the export. The first few lines of the file include commented text that you can set a parser to ignore.
To properly view the CSV file, open it with a text editor.
The file includes file header, device header and instance sections:
- File header - The 3 lines at the beginning of the file that identify the:
- Version of the export engine -
"# version
<VERSION NUMBER>"
- Cleanup type name -
"# cleanup type:","
<NAME>"
- Cleanup type code -
"# cleanup code:","
<CODE>"
where the code has one letter and two digits, such asC05
- Version of the export engine -
- Device header - The 3 lines before the instances from each device that identify the:
- Device name -
"# device:","
<DEVICE NAME>"
- Device vendor name -
"# type:","
<VENDOR NAME>"
- Instance format - The format for the instances for the cleanup type and vendor (see below)
- Device name -
- Instance - Each rule or object that matches the criteria for the cleanup
For each cleanup type and vendor, the instance format is:
Disabled Rules
Check Point |
|
Cisco |
|
Fortinet |
|
Juniper |
|
Palo Alto |
|
Duplicate Network Objects
The two lines before each set of duplicates are:
All vendors |
Number of duplicates and their matched properties
For example:
Instance format
Where For example: "Network","LAN","1.1.1.0/255.255.255.0","" |
Duplicate Services
The two lines before each set of duplicates are:
All vendors |
Number of duplicates and their matched properties
For example: Instance format
Where For example: "Service","sip-tcp","6","5060","Session Initiation Protocol over TCP" |
Empty Groups
All vendors |
Where For example: "Network group","Group1","","Internal Group" |
Fully Shadowed and Redundant Rules
Check Point |
|
Cisco |
|
Fortinet |
|
Juniper |
|
Palo Alto |
|
Unattached Objects
All vendors |
Where For example: "Network","Network_2_IPV6","2001:400:1:1::100/64","" |
Unused Objects
All vendors |
Where For example: "Network","Network_2_IPV6","2001:400:1:1::100/64","" |