06-08-2017 05:13 AM
06-08-2017 05:40 AM - edited 06-08-2017 05:40 AM
Export to Excel works. I have tried it.
Did not go through this guide to verify step by step at the moment but you get the basics.
06-08-2017 08:35 AM
It looks like the guide that @Raido_Rattameister shared is valid and will work appropriately. Personally I find it easier to export the XML directly and look at it that way you can look at the rules directly and look at the <service> setting which will list all <member> listing. Excel works perfectly fine though.
06-08-2017 02:16 PM
I also prefere the XML and in combination with the very powerful xpath "language" this task could be done with a one-liner and will give you all the rules with service objects in one view
06-08-2017 02:22 PM
Thanks all I used Pan-configurator and was able to get it pretty easy:
bash-3.2$ php rules-edit.php in=api://x.x.x.x actions=exportToExcel:rules.xls location=PALO-TIAA-FWHA03-QIC ruletype=security
- object 'QIC-C3_IS_T3' passing through Action='exportToExcel' Args: filename=rules.xls, additionalFields=,
- object 'QIC-C3_IS_T1' passing through Action='exportToExcel' Args: filename=rules.xls, additionalFields=,
- action 'exportToExcel' has tasks to process before shutdown.
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!