UIM A query to show all metrics and current value for a source.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

This query provided a list of all the metrics being collected and the current value for a source. 

Environment

Release : 20.1, 20.3

Component : UIM - UMP_REPORTS

Resolution

SELECT 
def.source,
def.probe,
cb.met_description,
def.target, 
def.qos,
snap.samplevalue,
snap.sampletime,
def.r_table,
def.table_id 
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] > dateadd(hour, -1, getdate())
AND source like '%sourcename%'
order by def.qos asc

Additional Information

For multiple sources at one time change this line from:
AND source like '%sourcename%'
to:
AND source in ('sourcename1','sourcename2','sourcename3')