1 Reply Latest reply on Aug 24, 2010 8:22 AM by mezdem

    Top 10 Wireless Clients by Traffic Web Element Incorrect

    mezdem

      I have the Top 10 Wireless Clients by Traffic web element showing on my top 10 tab.

      This should show top 10 highest traffic clients...but it doesnt...

      The web element shows this..

       

      But i know for certain that a client on an AP has used over 3.2 GB of data Tx.. but this does not show?

       

      This code shows the correct values..

      SELECT
       TOP 10
       rc.Client_MAC AS MAC_Address,
       rc.NodeID as NodeID,
       rc.Client_Name AS Name,
       AVG((rc.TotalBytesRxPerSec + rc.TotalBytesTxPerSec)) AS AVERAGE_of_Avg_Bps_Rx_Tx,
       AVG(rc.TotalBytesRxPerSec) AS AVERAGE_of_Avg_Bps_Rx,
       AVG(rc.TotalBytesTxPerSec) AS AVERAGE_of_Avg_Bps_Tx,
       SUM((rc.TotalBytesRxDiff + rc.TotalBytesTxDiff)) AS SUM_of_Total_Bytes_Rx_Tx,
       SUM(rc.TotalBytesRxDiff) AS SUM_of_Total_Bytes_Rx,
       SUM(rc.TotalBytesTxDiff) AS SUM_of_Total_Bytes_Tx
      FROM NPM_NV_WL_REPORT_CLIENTS_V rc
      INNER JOIN Nodes on Nodes.NodeID = rc.NodeID
      WHERE
      ( rc.DateTime BETWEEN DATEADD(day, -1, getdate() ) and getdate() )

      GROUP BY rc.Client_MAC, rc.Client_Name, rc.NodeID
      ORDER BY 6 DESC

      But it does not show what the access point name is?

      1. Can somone tell me why the standard Top XX Wireless Client by Traffic is showing incorrect data, and/or

      2. How do I link the above sql code to the AP_Name (that comes from a wireless controller).. so that I get a report of top 10, but in the same format as the below..Links the Client Traffic, the AP Name and the Controller.