Network Management

Hi to all, I would like to know if it is possible to take a report using Airwave and have the detailes status of all my Access Points to see the ports if is on 100 fast or 1000Giga, and also if those AP are in power save mode.

Please see the thread here;  http://community.arubanetworks.com/t5/Network-Management/AP-list-by-port-speed/m-p/252301/highlight/true#M3001

Hi, thank you for your answer, I found this post:

Try this:  

dbcsv "SELECT ap.name,interface.if_speed_in/1000000 AS connection_speed FROM ap INNER JOIN interface ON ap.id=ap_id WHERE interface.oper_status=1 ORDER BY connection_speed,ap.name" > ./intspeeds.csv

I've tried it, take a look:

Is that right ?

Try it without the line break between the i and the d:

dbcsv "SELECT ap.name,interface.if_speed_in/1000000 AS connection_speed FROM ap INNER JOIN interface ON ap.id=ap_id WHERE interface.oper_status=1 ORDER BY connection_speed,ap.name" > ./intspeeds.csv

Hi,

I tried it again and I think it worked:

Let me know if I type it in the right place, I put those comands on the Airwave logged as a Root. So if this were correct, where should I get those reports in cvs ?

Type "cat intspeeds.csv"

That's great, it work like a champs.

Just one more question, once I run it, it will get all the information of my Ap's right ?

Which should I add in this command line to get also the information if the AP is in Power saved mode ?

Unfortunately, that information is not stored in Airwave.  You will have to run the command below on your controller for all of your APs to find out which ones are in power save, or not:

(Aruba7640-US) #show ap debug system-status ap-name Office-225 | begin Power 
Power Status
------------
Operational State          POE-AT: No restrictions
-----------------          -----------------------
Current HW State           POE-AT: No restrictions

I undertand! However, I appreciate so much your help in this task.

Thank you :)