topic Re: Download AP file from WLC 5520 in Wireless

Download AP file from WLC 5520

andres. — Mon, 05 Jul 2021 20:20:53 GMT

Hello everyone,

I'm trying to download the AP list from my Cisco WLC 5520 and I can't find a way to do it. My intention is to download this list to get each AP's information like S/N, MAC address, model and version, etc., and put them in an Excel sheet.

Thank you in advance!

Andres

Re: Download AP file from WLC 5520

Wes Schochet — Tue, 25 May 2021 20:33:48 GMT

There is not a good way to do what you want. Te closest thing would be to do a "show ap summary" from the command line. You could do a "config paging disable" before to avoid the "more"prompt.

Re: Download AP file from WLC 5520

Leo Laohoo — Tue, 25 May 2021 22:43:17 GMT

@andres. wrote:

S/N, MAC address, model and version, etc.,

Other than S/N, MAC address, model, version, what other output do you want to see?

It cannot be done straightforward and will require two outputs.

First output will generate a list of APs.

config paging disable 
sh ap summary

Save that list as a txt file and open in Excel as a CSV. Then go to Data > Text to Columns to filter out only the AP names.

Use the list of AP names to generate the final list of output you want to see:

grep include Cisco.AP.Name|AP.Serial.Number|MAC.Address|AP.Model|IOS.Version "sh ap config general <AP_NAME>"

Hope this helps.

Re: Download AP file from WLC 5520

andres. — Wed, 26 May 2021 14:21:04 GMT

Thank you, Wes!

Re: Download AP file from WLC 5520

andres. — Wed, 26 May 2021 14:33:44 GMT

This was really helpful! Way simpler than what I previously thought.

Thank you so much for your help, Leo!

Re: Download AP file from WLC 5520

Wes Schochet — Wed, 26 May 2021 17:05:47 GMT

Nice!

Re: Download AP file from WLC 5520

dylan-v — Wed, 19 Feb 2025 13:26:57 GMT

grep include SN: "show ap inventory all"