Managed devices list export

[vseward]

I thought this would be something easy to look up and preform but I am obviously to optimistic.  What I would like to do is export a CSV or txt file with all the managed devices out of Panorama with thier device name, model, OS Version #, HA status, Management IP, serial number.  I can get all the information from the GUI under Panorama -> Managed Devices and then select the columns I want, but I cant export it. I rather not have to transcribe to excel 250 firewalls.  

[OtakarKlier]

Hello,

That does seem like a reasonable request. Reach out to your SE so they can add it to the wish list. Other than that I would suggest maybe doing a copy from panorama webpage into excel? I do this for our monthly audits of firewall changes. Its the only way I have found that is easy and works.

Hope that helps.

[Remo]

... and another use case for the API. This way you are already able to do what you want without waiting until you upgrade to 8.1 (yes with 8.1 it is possible to export a CSV from the panorama WebUI)

API Command:

https://PANORAMA/api/?key=APIKEY&type=op&cmd=<show><devices><all></all></devices></show>

[vseward]

Thanks for the response.  Is it possible to do this from the CLI.  It appears the API call is going to require setup and credentials setup.  Though there is some debate if it will be possible at all since we use dual factor authentication on the GUI. 

[Remo]

@vseward

If you are logged in to the WebUI (requires admin priviledges or at least API rights), then you can change the URL to https://PANORAMA/api. After that you should be able to click to the command in my last post (Operational Commands > show > devices > all). After that the xml list will be shown in the browser.

Cannot test right now, but its possible that you will get your list simply with the command "show devices all".