Users need to export group-associated firewall policies from the Symantec Endpoint Protection Manager (SEPM) into a readable/editable file for an audit.
Release : 14.3 RU3
Component : Firewall.
While SEPM's API access and the export option for firewall rules permits the conversion of the .dat file into raw XML, no internal option exists for exporting such rules or policies into a comma separated (CSV) file format for performing the audit in question.
Users can export individual firewall rules by highlighting all the rules of a policy with CTL-A, right-clicking, and selecting the export option.
Alternatively, users can export the entire policy from a right-click of the policy itself. The export will appear in the .dat file format.
Using a tool like 7zip can allow users to extract the contents of the .dat file into raw XML.
Users can then compose a script to convert the XML into CSV. Otherwise, Microsoft Office Excel provides an import option under the optional Developer tab that will import the raw XML (do not modify the original XML or it will not work) into a workable and editable CSV format.
The following link contains information for accessing the Developer tab in Excel:
The following link describes how to import XML into Excel using the Developer tab: