Download AP file from WLC 5520

[andres.]

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

[Wes Schochet]

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.

[andres.]

Thank you, Wes!

[Leo Laohoo · Accepted solution]

---

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

[andres.]

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

Thank you so much for your help, Leo!

[Wes Schochet]

Nice!