IOS-XE (9800) Export a list of APs via script

[PWJPW]

What is the best way to export (dump) a list of all AP's on a 9800 controller?

Is it just show ap summary ?

There are several thousand AP's and ideally I want to get an export in CSV format.

I plan to write a script to export and format as required.

Thanks!

[balaji.bandi]

we use old days in Prime, now in DNAC, do you have DNAC or Prime in your environment

check below script may help you (not tried) - but some point i will do. ( this script get you idea how can you get the information)

https://giters.com/yijxiang/Cisco_IOS_XE_rogue

[PWJPW]

No prime/DNA, just standalone controllers at this time.

Thanks for th script, will look¬

[Arshad Safrulla]

What is the purpose of exporting the list of AP's? If you just require the AP names show ap summary is more than enough. 

If you need to view the AP tags assigned to AP use show ap tag summary. Again it depends on what information you need capture and export. Below are some other useful commands if you want to grab detailed info

show ap name XXXX tag

show ap name XXXX tag detail

show ap config general

show ap config slot

show ap image

show ap cdp neighbors

show ap dot11 24ghz summary

show ap dot11 5ghz summary

[PWJPW]

We require the AP Name and the Base Radio MAC, that is all. Does show ap summary provide the radio MAC or just name?

Thanks

[Arshad Safrulla]

It will provide Radio MAC. Sample below

[PWJPW]

Perfect - is that safe to run when over 1000+ APs? How to get it without pagination etc.

Thanks

[Rich R]

"term len 0" turns off paging

Yes it should be fine.

[Arshad Safrulla]

Even of you use this, still it will list as pages. 10AP's per page. I would suggest to use filters like

sh ap summary | include  <some common part of the ap hostname> or other filters like exclude

[Rich R]

Hi @Arshad Safrulla maybe that's something that's been fixed in later releases.  On 17.6.1 it definitely presents it as one long list as you would expect when using term len 0.  I've just checked to make absolutely sure.

[Arshad Safrulla]

@Rich R  You are absolutely correct, I downgraded my LAB to 17.2.X to reproduce a bug, in that it was only 10 AP's per page. After upgrading the 17.3.4c it presents all as one long list. 

[PWJPW]

Thank you for the info.

[j.rambeau]

I wrote a script that does just that:

https://github.com/jrambeau/cisco-c9800-AP-inventory