fetch the average CPU usage for all robots using SQL command

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

This article provides a SQL query that will help you to fetch the average CPU usage for all the robots directly from the database.

Environment

DX UIM 20.4.x / 23.4.x

Resolution

SELECT
def.source,
def.target,
def.qos,
avg(snap.samplevalue) as cpu_usage
FROM S_QOS_DATA AS def
join cm_configuration_item_metric cm on cm.ci_metric_id=def.ci_metric_id
join cm_configuration_item_metric_definition cb on cm.ci_metric_type=cb.met_type
JOIN S_QOS_SNAPSHOT AS snap ON snap.table_id = def.table_id
WHERE snap.[sampletime] < '2025-02-10 09:02:06.000'  
and snap.[sampletime] > '2025-01-27 09:02:06.000'
and qos like '%QOS_CPU_USAGE%'
group by def.source, def.target, def.qos
order by def.qos asc
 

 

NOTE: adjust the datetime according to your requirements.