10-01-2014 10:19 AM
Can someone help me -
I am trying to run a report in airwave to display the Input Capacity of all the WAPs?
(To identify all APs connected at 100M)
I can see the information under APs/Devices->Monitor
|Enet0||18:64:72:C8:9F:42||0||Up||Up||gigabitEthernet||Full||N/A||100 Mbps||100 Mbps|
I just can't find the right variable in the report and I don't know psql well enough to find it via command line.
Solved! Go to Solution.
10-01-2014 11:45 AM
I've asked a similar question before and have placed a feature request on the "ideas" site. I've not looked in version 8 to see if they've added this.
I found the following commands that might be helpful. This is the first I've looked at this and don't have any idea where the info for speed is stored..
Put the databas schema into a file named amp_schema
pg_dump -Uairwave airwave --schema-only > amp_schema
Export all fields from the table ap to a csv file. I don't know if what is needed is in this table or not.
dbcsv "select * from ap" > aps.csv
10-01-2014 12:12 PM
I'm not sure if what I'm looking at is right, but this might provide what you need.
dbcsv "select ap.name,interface.if_speed_in,interface.oper_status from ap INNER JOIN interface ON ap.id=ap_id WHERE interface.oper_status=1"
10-01-2014 12:28 PM
This shows the type field:
dbcsv "select ap.name,ap.type,interface.if_speed_in,interface.oper_status from ap INNER JOIN interface ON ap.id=ap_id WHERE interface.oper_status=1" > intspeeds.csv
Type ID and AP Type
Again, I'm making this up as I go, but it looks sane.
11-06-2014 10:49 AM
Here is an updated version of the script that might be a bit more useful. It puts the ap info into a file, sends the file as an attachment, and then deletes the file. Someone that writes shell scripts can probably clean it up a bit.
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 AND (ap.type=296 OR ap.type=369 OR ap.type=464) ORDER BY connection_speed,ap.name" > ./intspeeds.csv
echo "Access Point Port Speeds" | mail -s "Port Speeds" -a intspeeds.csv firstname.lastname@example.org