Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Network Performance Monitor (NPM) > Top 25 Wireless Client by Traffic Rates over the Last 7 Days report not sorted in ascending/descending order

Top 25 Wireless Client by Traffic Rates over the Last 7 Days report not sorted in ascending/descending order

Created by Christine Magbuo, last modified by MindTouch on Jun 23, 2016

Views: 4 Votes: 0 Revisions: 7

Overview

This article addresses the issue where the Top 25 Wireless Client by Traffic Rate over the Last 7 Days report is not sorted in an ascending/descending order. 

Environment

All NPM versions

Cause

This occurs when the values under the AVERAGE_of_Avg_Bps_Tx or Average Transmit Bps column are the same. 

Steps

  1. Open Report Writer.
  2. Locate and edit the Top 25 Wireless Client by Traffic Rate over the Last 7 Days report.
  3. At the bottom of the query, replace ORDER BY 6 DESC with ORDER BY 7 DESC
  4. Click Execute SQL Query.

 

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

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

 

5. Report now shows in Megabyte(MB)

 

Last modified
23:46, 22 Jun 2016

Tags

Classifications

Public