Wireless Access

I've got a customer with 7k APs. Every couple of weeks or so we like to pull a list to compare up and down APs to compare to our packing lists, etc. I've been pulling this by copying the GUI list (by the thousand) into an excel sheet and sending in an email. This process is OK, but not my favorite.

I've been trying to make this process easier and hope you could help me. 

In the CLI i've tried running the "show ap database long sort-by ap-name" while logging the session to make the list quicker. The problem is that the list is cut up into groups of 20 by the flag declarations. Pulling a CLI list actually takes 3-4 times longer because of all the editting I have to do to make it readable. 

Is there a command I can run that will give me the printout of the GUI database without cutting the list into groups of 20? (i have diabled the paging during this process.)

Have you tried using no paging ?

And increase the windows size buffer ?

Do you have AirWave?

---

@cappalli wrote:

Do you have AirWave?

---

They have 2 Airwave servers. I haven't pulled an AP list like this from Airwave though. I'd have to compare the lists to make sure there wasn't discrepencies. I will probably try that when i'm a little less busy.

---

@playinpearls wrote:

---

@cappalli wrote:

Do you have AirWave?

---

They have 2 Airwave servers. I haven't pulled an AP list like this from Airwave though. I'd have to compare the lists to make sure there wasn't discrepencies. I will probably try that when i'm a little less busy.

---

This gave me pretty much what I want. Thanks!!

Paging is disabled. 

The problem is not that I can't pull the entire list....its that it is split up like this:

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
X = Maintenance Mode; P = PPPoE AP; B = Built-in AP
R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
M = Mesh node; Y = Mesh Recovery

Port information is available only on 6xx.

AP Database
-----------
Name Group AP Type IP Address Status Flags Switch IP Standby IP Wired MAC Address Serial # Port FQLN Outer IP User
---- ----- ------- ---------- ------ ----- --------- ---------- ----------------- -------- ---- ---- -------- ----

That's true that message will still be there.

What you could do is copy the whole list into Notepad ++ and then do a replace all

What you can do is use one of the columns that is not populated with data. For example, in a campus environment, the "Outer IP" column is not used and will be "N/A" for all access points.

So the command below will return what you are looking for:

show ap database long sort-by ap-name | include N/A

I had thought about that, but when I pull from the GUI, all the columns are in order. When pasting into excel from the CLI, the down aps dont have an IP so the column is shorter than the rest, etc. I know thats picky but i'm just trying to figure out the easiest way for me to pull a list that needs minimal editting before a non-techie can read it.  Especially when the list is 7k long.

---

@victorfabian wrote:

That's true that message will still be there.

 

What you could do is copy the whole list into Notepad ++ and then do a replace all

 

---

7k is pretty long but you could show ap database | exclude Down

If you are trying to track AP's that might be missing, you won't want to exclude Down. 

Every AP will have at least 1 N/A designation and will hit the filter.