Difference between revisions of "Exporting rules to Excel"
(Created page with "Category:Palo Alto In the Web GUI select Device > Setup > Operations and click on Export Named Configuration Snapshot From the pop-up menu select running-config.xml, and...") |
|||
| Line 19: | Line 19: | ||
To export Address-Groups, generate a new copy of running-config.xml and save it as address-group.xml. | To export Address-Groups, generate a new copy of running-config.xml and save it as address-group.xml. | ||
| − | Search for tag <address-group> and delete all the text before this tag and also delete all the text after the tag </address-group> | + | Search for tag <address-group> and delete all the text '''before''' this tag and also delete all the text '''after''' the tag </address-group> |
Revision as of 20:27, 20 September 2016
In the Web GUI select Device > Setup > Operations and click on Export Named Configuration Snapshot
From the pop-up menu select running-config.xml, and click OK
Now edit the xml file and remove all tags until the first <security>, and also remove all tags after </security>
Add a header: <?xml version="1.0" encoding="UTF-8"?>
Now do a find and replace option for keyword <member>, replace <member> with blank (nothing)
Save as policy.xml
Open a new Excel Spreadsheet and click on MenuBar DATA > From Other Sources > From XML Data import
To improve visualisation, replace “ “ (space) with blank (nothing)
To export Address-Groups, generate a new copy of running-config.xml and save it as address-group.xml.
Search for tag <address-group> and delete all the text before this tag and also delete all the text after the tag </address-group>