Reset Search
 

 

Article

How does the Wireless Summary Controller Report display data?

« Go Back

Information

 
TitleHow does the Wireless Summary Controller Report display data?
Question
How does the Wireless Summary Controller Report display data?
 
Environment
  • Extreme Management Center
  • ExtremeWireless
Answer
In Extreme Management Center click on the wireless tab -> Dashboard. The XML report for this screen can be found at: /usr/local/Extreme_Networks/appdata/OneView/Reports/WmDashbaord.xml

If some data is not being populated, or is populated incorrectly this article will identify how each panel works to display information to help troubleshoot the issue.
  1. The top panel summary:
 User-added image

Data is determined by mysql query to the database. Wireless Controller Statistics must be enabled to populate the database with information to display.

Bold text is mysql query string

Client XML: select "Clients" displayName,group_concat(time_stamp) times,group_concat(truncate(average,0)) vals from (select time_stamp, sum(average) average from netsightrpt.rpt_default_hour where statisticID=(select statisticID from netsightrpt.rpt_statistic where name="NetworkAssociatedClients") and (time_stamp/1000) between (unix_timestamp() - (60 * 60 * 24)) and unix_timestamp() group by time_stamp order by time_stamp asc) a;

Active APs: select "Active APs" displayName,group_concat(time_stamp) times,group_concat(truncate(average,0)) vals from (select time_stamp, sum(average) average from netsightrpt.rpt_default_hour where statisticID=(select statisticID from netsightrpt.rpt_statistic where name="NetworkTotalActiveAps") and (time_stamp/1000) between (unix_timestamp() - (60 * 60 * 24)) and unix_timestamp() group by time_stamp order by time_stamp asc) a;

Wireless Bandwidth: select "Wireless Bandwidth" displayName,group_concat(time_stamp) times,group_concat(truncate(average,1)) vals from (select time_stamp, sum(average) average from netsightrpt.rpt_default_hour where statisticID=(select statisticID from netsightrpt.rpt_statistic where name="NetworkWirelessTotalBwKbps") and (time_stamp/1000) between (unix_timestamp() - (60 * 60 * 24)) and unix_timestamp() group by time_stamp order by time_stamp asc) a;

Network Bandwidth: select "Network Bandwidth" displayName,group_concat(time_stamp) times,group_concat(truncate(average,1)) vals from (select time_stamp, sum(average) average from netsightrpt.rpt_default_hour where statisticID=(select statisticID from netsightrpt.rpt_statistic where name="NetworkTotalBwKbps") and (time_stamp/1000) between (unix_timestamp() - (60 * 60 * 24)) and unix_timestamp() group by time_stamp order by time_stamp asc) a;
 
  1. Wireless Overview
User-added image
The Wireless overview is displayed by using the "wmoverviewgrid" item in the XML for the report. This data is generated from the WirelessDomainManager. The method DwrWireless.getWmOverview calculates all counts fetched from the WDM and populates this array. The Wireless Domain manager information can be in in Extreme Management Center --> Administration --> Diagnostics --> Wireless --> Wireless Domain Data 
  1. Clients by Protocol 
User-added image

This panel uses the following statistical targets to display data:

NetworkStationsA
NetworkStationsB
NetworkStationsG
NetworkStationsN24
NetworkStationsN50
NetworkStationsUnavailable
NetworkStationsError
NetworkStationsAC
 
  1. APs by Channel
User-added image

SELECT CONCAT(substring(displayName,9), ' [', TRUNCATE(r.val,0), ']') as displayVal,
TRUNCATE(r.val,0) as averageVal FROM netsightrpt.rpt_default_raw r LEFT OUTER JOIN
netsightrpt.rpt_target t on r.targetID=t.targetID
WHERE statisticID=(SELECT statisticID FROM netsightrpt.rpt_statistic s WHERE s.name='NetworkApByChannelAps')
AND time_stamp > UNIX_TIMESTAMP(NOW() - INTERVAL 20 MINUTE) * 1000 GROUP BY displayName
ORDER BY r.val DESC LIMIT 8;
 
  1. Controller Summary
User-added image

Rendered by: 

controllermugrid

 
  1. Wireless Bandwidth
User-added image

The following statistical target is used: 

​NetworkWirelessTotalBwKbps
  1. Events
User-added image

Event log: events from the "WirelessEventLog" that can be found in "Alarms & Events" and filtering on "Wireless". 


 
  1. Clients by Protocol
User-added image

The following statistical targets are used: 

NetworkStationsA
NetworkStationsB
NetworkStationsG
NetworkStationsN24
NetworkStationsN50
NetworkStationsUnavailable
NetworkStationsError
NetworkStationsAC
 
  1. Top APs
User-added image

Top AP information is displayed using the following statistical data sets: 

ApWirelessTotalBwKbps
ApTotalBwKbps
ApAssociatedClients
ApValidPercent
ApErrorPercent
ApWirelessValidPercent
pWirelessErrorPercent
 
 
 
Additional notes
Statistical Targets: 
  • You can obtain a list of statistical targets and how they are calculated by going in Extreme Management Center --> Administration --> Diagnostics --> Set the "Level" to "Diagnostic" --> Historical Statistics Collector -> Statistics
  • This can be exported to CSV by pressing the document with the "x" in the upper right-hand section of the window.

 

Feedback

 

Was this article helpful?


   

Feedback

Please tell us how we can make this article more useful.

Characters Remaining: 255