How to retrieve AP Client Statistics via API

Question:

Can I retrieve the metrics that AKIPS collects from our WLC about the number of clients connected to our WAPs?

Answer:

Nearly anything that you see in a graph can be retrieved from the time series database using the API Command Console, as this is what we do behind the scenes in the reports.

For example, the AP wap-cisco-246-124 has an average of 10 clients on the 'a' radio and 4 clients on the 'abgn' radio for the last 30mins.

You can retrieve the individual per minute values from the API Command Console for each radio.

wap-cisco-246-124 radio.80.47.168.16.47.96.0 AIRESPACE-WIRELESS-MIB.bsnApIfNoOfUsers = 4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4
wap-cisco-246-124 radio.80.47.168.16.47.96.1 AIRESPACE-WIRELESS-MIB.bsnApIfNoOfUsers = 10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10
ok: series time last30m * wap-cisco-246-124 * AIRESPACE-WIRELESS-MIB.bsnApIfNoOfUsers

The radio child ie 'radio.80.47.168.16.47.96.0' is listed as it is in our database, which is roughly the format that it is stored in the controller (we just prepend radio to it when we put it in the database). When we display the radios in a report, we list the common name for the radio which we retrieve from the CISCO-LWAPP-AP-MIB.cLApDot11IfType OID.

wap-cisco-246-124 radio.80.47.168.16.47.96.0 CISCO-LWAPP-AP-MIB.cLApDot11IfType = 4,dot11abgn,1709276062,1709276062,
wap-cisco-246-124 radio.80.47.168.16.47.96.1 CISCO-LWAPP-AP-MIB.cLApDot11IfType = 2,dot11a,1709276062,1709276062,
ok: mget * wap-cisco-246-124 * CISCO-LWAPP-AP-MIB.cLApDot11IfType

You can also use the 'calc avg' command to show the same avg for a time period that you see in the earlier screen capture for 'Cisco WLAN Access Point Radio'. You need to list the radios separately though. If you just did 'calc avg time last30m * wap-cisco-246-124 * AIRESPACE-WIRELESS-MIB.bsnApIfNoOfUsers' for both radios, you would get an n/a because we can't calculate across different children.

4
ok: calc avg time last30m * wap-cisco-246-124 radio.80.47.168.16.47.96.0 AIRESPACE-WIRELESS-MIB.bsnApIfNoOfUsers
10
ok: calc avg time last30m * wap-cisco-246-124 radio.80.47.168.16.47.96.1 AIRESPACE-WIRELESS-MIB.bsnApIfNoOfUsers 

In terms of aggregates, we have an aggregate option under the Tools -> Graph Reporter. Filter for the APs you want and click the "Aggregate" button at the bottom. Note that this is the aggregate for those 10 APs across both radios.

You can also retrieve this information from the API Command Console:

42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42
ok: aggregate avg time last30m * /wap-cisco-246-12./ * AIRESPACE-WIRELESS-MIB.bsnApIfNoOfUsers