Exporting a list of Panorama managed devices with software version included

Reply
Highlighted
L0 Member

Exporting a list of Panorama managed devices with software version included

Does anyone know how to export, to csv, a list of all managed devices from Panorama?

 

Thanks,

Highlighted
L3 Networker

Re: Exporting a list of Panorama managed devices with software version included

In April, I was told directly by support that exporting the device list was not supported.

Highlighted
L7 Applicator

Re: Exporting a list of Panorama managed devices with software version included

there's an API that will return all managed devices in XML format:

 

/api/?type=op&cmd=<show><devices><all></all></devices></show>

 

 

 

 

reaper - PANgurus.com
I drink and I know things
Highlighted
L0 Member

Re: Exporting a list of Panorama managed devices with software version included

This worked great.  Thanks for the tip.

 

This external wiki shows how to open and convert the XML file into MS Excel.

 

https://www.wikihow.com/Convert-XML-to-Excel

Highlighted
L4 Transporter

Re: Exporting a list of Panorama managed devices with software version included

Panorama tab --> Managed Devices --> Summary

Click the PDF/CSV export icon at the bottom of the list.

Voila! More information that you'll ever need (including serial numbers and PanOS versions), in a fancy PDF or simple text file.

 

Works just fine on PanOS 8.1.12.

 

Whoops, just noticed this is a thread from 2016. 

Highlighted
L0 Member

Re: Exporting a list of Panorama managed devices with software version included

This absolutely worked for me. Thanks! 

Saved me a ton of manual effort. 

Still works in 2020. 

Highlighted
L0 Member

Re: Exporting a list of Panorama managed devices with software version included

I should be more specific. 

On 8.1.7 it works great. 

But I also tried it on a Panorama with 7.1.16, and although you can view the list in similar fashion, there is no option to export to .CSV. 

Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

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 Live Community as a whole!

The Live Community thanks you for your participation!