search cancel

Dashboard TOP 10 for CPU memeory of servers

book

Article ID: 240158

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

How to create a dashboard with TOP 10 CPU and MEMORY of servers. 

 

 

Environment

Release : 20.3

Component : UIM OPERATOR CONSOLE - DASHBOARDS/DESIGNER

Resolution

 There is no default top-N dashborad for CPU/ memory usage.. 

Either you have to use the create customized dashboard from cabi following the TOP N  CPU memeory report query .

OR 

For dashboard designer > use the custom query  use a a custom query that returns the TOP 10 CPU usage servers and build a custom SQL Table widget using that query.

 Below  query for getting top cpu usage machines

SELECT  qd.source, 
       qd.qos,         
       qs.samplevalue
  FROM cm_computer_system cs 
         INNER JOIN 
       cm_device d ON d.cs_id = cs.cs_id 
         INNER JOIN 
       cm_configuration_item ci ON ci.dev_id = d.dev_id 
         INNER JOIN 
       cm_configuration_item_metric cim ON cim.ci_id = ci.ci_id 
         INNER JOIN 
       s_qos_data qd ON qd.ci_metric_id = cim.ci_metric_id 
         INNER JOIN 
       s_qos_snapshot qs ON qd.table_id = qs.table_id   
  WHERE qos = 'QOS_CPU_USAGE'  AND qs.sampletime > '2022-04-01 00:00:00.000' 
  ORDER BY samplevalue desc


Change the qos value based on  your requirement.