Generate Top N CPU and Memory Utilization Reports (DX UIM)

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

You need to generate a report identifying the top 10 servers with peak CPU and memory utilization over a specific period in DX Unified Infrastructure Management (DX UIM). You find that these reporting options are not available in your current version (e.g., 23.4 CU6).

Environment

UIM 23.4 CU6

Cause

The "Top N" reporting dashboard is a new feature introduced in DX UIM 23.4 CU7 (UIM BI) and is not natively present in earlier cumulative updates like CU6.

Resolution

Fixed in release 23.4 CU7 and higher. 

If you are using a version prior to 23.4 CU7, you can use the following SQL queries as a workaround to extract this data directly from the database. 

CPU Usage Query Review this command before running it.

sql

SELECT TOP 10 
      CS.NAME AS [DEVICE NAME], 
      CS.IP, 
      SQS.samplevalue AS [CPU USAGE (%)] 
FROM S_QOS_DATA SQD (NOLOCK) 
INNER JOIN S_QOS_SNAPSHOT SQS (NOLOCK) ON SQD.table_id = SQS.table_id  
INNER JOIN CM_CONFIGURATION_ITEM_METRIC CIM (NOLOCK) ON SQD.ci_metric_id = CIM.ci_metric_id 
INNER JOIN CM_CONFIGURATION_ITEM CI (NOLOCK) ON CI.ci_id = CIM.ci_id 
INNER JOIN CM_DEVICE CD (NOLOCK) ON CI.dev_id = CD.dev_id 
INNER JOIN CM_COMPUTER_SYSTEM CS (NOLOCK) ON CD.cs_id = CS.cs_id 
INNER JOIN CM_GROUP_MEMBER CGM (NOLOCK) ON CGM.cs_id = CS.cs_id 
INNER JOIN CM_GROUP CG (NOLOCK) ON CG.grp_id = CGM.grp_id 
WHERE SQD.probe = 'cdm' 
    AND CG.name = '####' --Specify your group name 
    AND SQD.qos = 'QOS_CPU_USAGE' 
    AND SQS.sampletime > DATEADD(day, -7, GETDATE()) --Last 7 days 
    AND SQD.target NOT IN ('Idle', 'System', 'User', 'Wait') 
ORDER BY [CPU USAGE (%)] DESC;

 

 

Memory Usage Query Review this command before running it

sql

SELECT TOP 10 
      CS.NAME AS [DEVICE NAME], 
      CS.IP, 
      SQS.samplevalue AS [MEMORY USAGE (%)] 
FROM S_QOS_DATA SQD (NOLOCK) 
INNER JOIN S_QOS_SNAPSHOT SQS (NOLOCK) ON SQD.table_id = SQS.table_id  
INNER JOIN CM_CONFIGURATION_ITEM_METRIC CIM (NOLOCK) ON SQD.ci_metric_id = CIM.ci_metric_id 
INNER JOIN CM_CONFIGURATION_ITEM CI (NOLOCK) ON CI.ci_id = CIM.ci_id 
INNER JOIN CM_DEVICE CD (NOLOCK) ON CI.dev_id = CD.dev_id 
INNER JOIN CM_COMPUTER_SYSTEM CS (NOLOCK) ON CD.cs_id = CS.cs_id 
INNER JOIN CM_GROUP_MEMBER CGM (NOLOCK) ON CGM.cs_id = CS.cs_id 
INNER JOIN CM_GROUP CG (NOLOCK) ON CG.grp_id = CGM.grp_id 
WHERE SQD.probe = 'cdm' 
    AND CG.name = '####' --Specify your group name 
    AND SQD.qos = 'QOS_MEMORY_PERC_USAGE' 
    AND SQS.sampletime > DATEADD(day, -7, GETDATE()) --Last 7 days 
ORDER BY [MEMORY USAGE (%)] DESC;