Wireless Access

Reply
Community Administrator
Posts: 2,254
Registered: ‎12-03-2013

How to: "Export" AP database to Excel

How to export an AP database to Excel.
 

Log into the CLI of your controller. Issue the command “show ap database”. The output is:Show ap database.PNG

 

Now copy the output

 

Show ap database- copy.PNG

 

Paste the output into a .txt document. Save the document.

 

ap lits.PNG

 

Open Excel, navigate to data > from text >and find the .txt file. This will start an import wizard. Sail through the wizard by accepting the default settings. Upon completion of the wizard you will need to place the data or just click “OK”

 

TI 1.PNG

 

You are finished.

 

Finished export.PNG

  1.  
CWNA, ACMP, Security +
Guru Elite
Posts: 8,340
Registered: ‎09-08-2010

Re: How to: "Export" AP database to Excel

You can also do:

 

show ap database | redirect-output

 

It is handy for large lists. It creates a text file of the output in the flash.


Tim Cappalli | Aruba Security TME
@timcappalli | timcappalli.me | ACMX #367 / ACCX #480
Contributor II
Posts: 36
Registered: ‎01-14-2014

Re: How to: "Export" AP database to Excel

if you have airwave better grab a csv file from there.

Search Airheads
Showing results for 
Search instead for 
Did you mean: