topic Managed devices list export in General Topics

Managed devices list export

vseward — Mon, 12 Mar 2018 22:57:50 GMT

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.

Re: Managed devices list export

OtakarKlier — Tue, 13 Mar 2018 21:05:45 GMT

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.

Re: Managed devices list export

Remo — Tue, 13 Mar 2018 22:06:32 GMT

... 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>

Re: Managed devices list export

vseward — Wed, 14 Mar 2018 19:38:49 GMT

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.

Re: Managed devices list export

Remo — Wed, 14 Mar 2018 21:56:15 GMT

@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".