topic Dump a list of LWAPP's including Serial #'s in Wireless

Dump a list of LWAPP's including Serial #'s

lcnorwood — Sun, 04 Jul 2021 06:15:11 GMT

Is there a way from the console or from the web interface to dump a list/inventory of LAP's tied to a particular controller, including IP's and serial #'s?

Trying to save myself a ton of work...

Dump a list of LWAPP's including Serial #'s

Leo Laohoo — Wed, 19 Dec 2012 22:04:20 GMT

Without WCS/NCS/CPI? No.

Dump a list of LWAPP's including Serial #'s

daviwatk — Wed, 19 Dec 2012 23:59:10 GMT

While a bit cumbersome; it's feasible. It would require some legwork and post-collection formatting. From the CLI...

To see list of AP names and IPs you could perform

>show dtls connections

Any AP that has CAPWAP control path up (joined to WLC) would appear here with AP name and "Peer IP"

For pulling serial number; this is pretty tedious, but you could script this out

You would need to execute the following for each ap

>debug ap enable

>debug ap command "show ver | inc Serial"

May even try "PCB Serial Number" as the "include" for relevant SN

You will get some extra outputs regarding the WLC task, timestamps, and MAC, but you will see the value of this "command" returned to the WLC screen afterwards.

Again, this isn't pretty, but can it be done; yes. Leo's suggestions would be much easier

Re: Dump a list of LWAPP's including Serial #'s

Scott Fella — Thu, 20 Dec 2012 07:54:35 GMT

You could run this command also

show ap config general

Sent from Cisco Technical Support iPhone App

Dump a list of LWAPP's including Serial #'s

daviwatk — Thu, 20 Dec 2012 17:35:20 GMT

Making it easy on him eh? Good call Scott.

Dump a list of LWAPP's including Serial #'s

Scott Fella — Thu, 20 Dec 2012 17:39:16 GMT

I still don't think that is easy... you would need to take that data an run it through something that might be able to just export what you need... I would not want to have to go through a list of even 100 of these:)

Thanks,

Scott

Help out other by using the rating system and marking answered questions as "Answered"

Dump a list of LWAPP's including Serial #'s

lcnorwood — Thu, 20 Dec 2012 17:41:42 GMT

Yeah, easy is always awesome. i'm curious if this would show in a show tech. I don't mind digging a little for the info, but don't want to do a bunch of tedious commands, as we're in the middle of doing our smartnet renewals (No, not everything was purchased with smartnet GRRR)

Come on cisco, isn't there a way to make this easier?

Dump a list of LWAPP's including Serial #'s

Scott Fella — Thu, 20 Dec 2012 17:44:15 GMT

It will... but if you have a lot of AP's, you better watch the CPU when you issue that command.. by a lot, I mean 1000+

Thanks,

Scott

Help out other by using the rating system and marking answered questions as "Answered"

Dump a list of LWAPP's including Serial #'s

lcnorwood — Thu, 20 Dec 2012 17:47:18 GMT

We're under 100 for the moment.

Dump a list of LWAPP's including Serial #'s

lcnorwood — Thu, 20 Dec 2012 19:03:53 GMT

The show tech didn't work.

Dump a list of LWAPP's including Serial #'s

Scott Fella — Thu, 20 Dec 2012 19:22:46 GMT

show run-config has the info

Thanks,

Scott

Help out other by using the rating system and marking answered questions as "Answered"

Re: Dump a list of LWAPP's including Serial #'s

patrick.kofler — Fri, 21 Dec 2012 16:44:51 GMT

Before using the WCS I also did things like that on a regular basis. I found that with Notepad++ and Excel I had the correct tools to get that information fast and in a clear overview.

Anyways,

Log into the CLI of the WLC. Setup your terminal software to send the output directly into a text file.

config paging disable
show access-point-config (a hidden command, which is basically the same as show ap config general, but you don't need to enter each and every AP name. Just keep pressing the enter button, until the WLC is through all APs)

You can then stop logging the terminal session and quit.

Now this file contains every information you need and more.

For the next step you will need Notepad++ as well as a certain plugin called Python Script and TextFX (the latter one should already come with the editor, if not search the plugins for "TextFX Characters")

You can download it directly via Notepad++ by going to Plugins->Plugin Manager. Under Available search for "Python Script"

Once installed you can write & execute scripts.

Now open up Notepad++ and go again to Plugins->Python Script->New Script. You will be asked for a path where you want to save that script. Once done paste the following code into the script (cannot attach the actual script to this post)

editor.rereplace(r"(^AP Serial Number.*)", r"\1\r\n#")

editor.selectAll()

notepad.runMenuCommand("TextFX Edit", "Delete Blank Lines")

editor.rereplace(r"(\w)\r\n", r"\1;")

editor.replace(r";#","")

notepad.runMenuCommand("TextFX Edit", "Delete Blank Lines")

It certainly is not perfect as I am not that good in this thing, but it gets the job done. Previously I did all those steps by hand

Save the script and open up the file where you have logged your terminal output and execute the script via Plugins->Python Script->Scripts->your_script.py

Mind you that the finished output might show duplicate entries. That is because the show access-point-config separates an AP by its installed radios. So you will see two entries for a dual band AP.

The script might take some minutes to complete, so just let it run through.

Once complete you are able to export the output to excel and use the "text to columns" feature where you chose the semicolon as separator. Before you can run "Remove Duplicates" so you get rid of the redundant entries.

Now you should have a file where you have all the informations you need.

HTH

Regards,

Patrick

Re: Dump a list of LWAPP's including Serial #'s

lcnorwood — Fri, 21 Dec 2012 17:09:06 GMT

Patrick -

That was OUTSTANDING! Thank you very much!

Re: Dump a list of LWAPP's including Serial #'s

George Stefanick — Fri, 21 Dec 2012 17:23:29 GMT

Patrick ..

Hit me up in PM .. I would like to ask you a question ..

__________________________________________________________________________________________
"Satisfaction does not come from knowing the solution, it comes from knowing why." - Rosalind Franklin
__________________________________________________________________________________________
‎"I'm in a serious relationship with my Wi-Fi. You could say we have a connection."

Dump a list of LWAPP's including Serial #'s

Leo Laohoo — Fri, 21 Dec 2012 21:04:39 GMT

Nice!

Re: Dump a list of LWAPP's including Serial #'s

james.grundy@bt.com — Thu, 27 Dec 2018 21:40:05 GMT

Thank you for the information, that was very helpful, I will have to explore Python scripting some more.

Re: Dump a list of LWAPP's including Serial #'s

darin.gottman1 — Thu, 20 Jun 2019 22:04:33 GMT

I used grep include "Cisco AP Name|AP Model|AP Serial Number" "show access-point-config" to get the results that I needed. Logged it to a file in my terminal application and then used that file to get the data into Excel.

Re: Dump a list of LWAPP's including Serial #'s

turtle007 — Thu, 10 Oct 2019 20:05:46 GMT

The grep solution worked great. I added BSSID to get the Base MAC address.
grep include "Cisco AP Name|MAC Address|BSSID|AP Model|AP Serial Number" "show access-point-config"

Re: Dump a list of LWAPP's including Serial #'s

Ken Hagen — Wed, 13 Nov 2019 00:18:12 GMT

Can you tell me what version of Notepadd++ ? I'm not seeing that plugin.

Re: Dump a list of LWAPP's including Serial #'s

Koeberleinr — Tue, 16 Jun 2020 23:01:39 GMT

Patrick,
I know this was several years ago, but I was wondering if this script can be modified to pull that Mac Address as well.

Here is what I came up with, but it doesn't seem to work, any ideas?

editor.rereplace(r"(^AP Serial Number.*)", r"\1\r\n#")

editor.selectAll()

notepad.runMenuCommand("TextFX Edit", "Delete Blank Lines")

editor.rereplace(r"(\w)\r\n", r"\1;")

editor.replace(r";#","")

notepad.runMenuCommand("TextFX Edit", "Delete Blank Lines")