1 Reply Latest reply on Apr 7, 2015 8:25 AM by slash-doom

    Combine Wireless Reports

    sotherls

      I am trying to figure out how to add the Access Points to the "Top 25 Wireless Client by Traffic Rates over the last 7 days" report.

       

      Any ideas?

        • Re: Combine Wireless Reports
          slash-doom

          If you're looking at autonomous access points I think you could do something like...

           

          SELECT

            TOP 25

            rc.Client_MAC AS Client_MAC,

            rc.Client_Name AS Client,

            Nodes.Caption as Node,

            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, -7, getdate() ) and getdate() )

           

          GROUP BY rc.Client_MAC, rc.Client_Name, Nodes.Caption

          ORDER BY 6 DESC

           

          But if you're looking at LWAPs I think that's just going to show you the name of the controller as the node.