Cisco WLC 9800-40

[jain.manish94]

Hello Team,

I need your help to export all the access point details with IP of AP, Name , serial number of AP.

I am running command show ap summary but it is not giving me serial number of AP.

I have 10 9800-48 and around 5000 access point. It is very difficult to get the serial number of each AP one by one.

[Flavio Miranda]

@jain.manish94 

 I believe you are going to need a combination of commands show ap summary and show ap inventory. If you have code skills it coud be done using script but, if not, run both commands, export to a txt file and open in excel. Then use filter and formulas to get the information you need.  I dont believe there will be one command fits all on this case. 

[jain.manish94]

Show ap inventory is not working on 9800-40 wlc 

Is there any other commands 

[Flavio Miranda]

Actually, there is a better way. 

Create a spreadsheet and add this command in the first line

show ap name AP01 config general (replace AP01 by your AP name)

Then, replicate this to all your AP and run on the WLC. This command will have the information you need. 

Device# show ap name AP01 config general

Cisco AP Name                                   : AP01
Cisco AP Identifier                             : 5
Country Code                                    : US  - United States
Regulatory Domain Allowed by Country            : 802.11bg:-A     802.11a:-A
AP Country Code                                 : US  - United States
AP Regulatory Domain                            : Unconfigured
Switch Port Number                              : Te1/0/1
MAC Address                                     : 0000.2000.02f0
IP Address Configuration                        : Static IP assigned
IP Address                                      : 10.10.10.12
IP Netmask                                      : 255.255.0.0
Gateway IP Address                              : 10.10.10.1
Fallback IP Address Being Used                  : 10.10.10.12
Domain                                          : Cisco
Name Server                                     : 0.0.0.0
CAPWAP Path MTU                                 : 1485
Telnet State                                    : Enabled
SSH State                                       : Disabled
Cisco AP Location                               : sanjose
Cisco AP Group Name                             : default-group
Primary Cisco Controller Name                   : CAPWAP Controller
Primary Cisco Controller IP Address             : 10.10.10.1
Secondary Cisco Controller Name                 :
Secondary Cisco Controller IP Address           : Not Configured
Tertiary Cisco Controller Name                  :
Tertiary Cisco Controller IP Address            : Not Configured
Administrative State                            : Enabled
Operation State                                 : Registered
AP Mode                                         : Local
AP Submode                                      : Not Configured
Remote AP Debug                                 : Disabled
Logging Trap Severity Level                     : informational
Software Version                                : 7.4.0.5
Boot Version                                    : 7.4.0.5
Stats Reporting Period                          : 180
LED State                                       : Enabled
PoE Pre-Standard Switch                         : Disabled
PoE Power Injector MAC Address                  : Disabled
Power Type/Mode                                 : Power Injector/Normal Mode
Number of Slots                                 : 2
AP Model                                        : 1140AG
AP Image                                        : C1140-K9W8-M
IOS Version                                     :
Reset Button                                    :
AP Serial Number                                : SIM1140K001
AP Certificate Type                             : Manufacture Installed
Management Frame Protection Validation          : Disabled
AP User Mode                                    : Customized
AP User Name                                    : cisco
AP 802.1X User Mode                             : Not Configured
AP 802.1X User Name                             : Not Configured
Cisco AP System Logging Host                    : 255.255.255.255
AP Up Time                                      : 15 days 16 hours 19 minutes 57
 seconds
AP CAPWAP Up Time                               : 4 minutes 56 seconds
Join Date and Time                              : 10/18/2012 04:48:56
Join Taken Time                                 : 15 days 16 hours 15 minutes 0
seconds
Join Priority                                   : 1
Ethernet Port Duplex                            : Auto
Ethernet Port Speed                             : Auto
AP Link Latency                                 : Disabled
Rogue Detection                                 : Disabled
AP TCP MSS Adjust                               : Disabled
AP TCP MSS Size                                 : 6146

[jain.manish94]

This is good command but I have 500 access point, 400 access point on each controller 9800-40 and this would be big file and then need to arrange again with require details.

Any other commands where I can run two  commands together.

[Flavio Miranda]

 There is no easy way to do this. 

[Scott Fella]

@jain.manish94 like what @Flavio Miranda mentioned, there is not a simple method without parsing the data.  What I typically do is as an example, I would capture the whole output for: show ap config general

I would then use a tool like EditPad Pro or you can use Visual Studio Code, anything that allows you to write a regular expression.  Then you build your expression and then cut or copy the match.  This worked as I just tested it out, of course you can add or modify the expression.

^Cisco AP Name.*$|^IP Address\s{2}.*$|^AP Serial Number.*$

The other method would be to write a script in python or Ansible that extracts the data you need to a file.

[Scott Fella · Accepted solution]

You can also use Leo's regex ex in this thread for reference:
https://community.cisco.com/t5/wireless/download-ap-file-from-wlc-5520/td-p/4408419

terminal length 0
show ap config general | in Cisco.AP.Name|AP.Serial.Number|^MAC.Address|AP.Model|IOS.Version

[jasondodge]

I think this can be done easily with the config analyzer tool. Upload your show tech wireless to it, then check the "APs Configuration" tab in the exported CSV.  It is a tab deep to the right of the workbook.

It provides the following information for all your APs in one nice sheet:

Name

Model

Admin Status

Eth Mac

ID

Serial

Mode

AP group/Site

Flex group/Site

Tag Assignament

Location

Power State

Primary Controller

Secondary Controller

Tertiary Controller

Primary Controller IP

Secondary Controller IP

Tertiary Controller IP

Mgmt User

IP

Mask/Prefix

Gateway

IP Type

CAPWAP MTU

Uptime

CAPWAP Uptime

TCP-MSS

Rogue Detection

VLAN Support

LAG Conf

LAG Support

[Leo Laohoo]

Use the GUI and export the output to an Excel sheet.