Extract Monitored Processes that are Generating QOS from a UIM Domain

book

Article ID: 236749

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have a requirement from a user to provide all processes configured for with QOS monitoring in UIM for all servers. 

Environment

Release : 20.3

Component : UIM - PROCESSES

Resolution

The below query can be used to list all active QOS related to the processes probe. There is also an option to allow to limit to a single host.

SELECT 
def.source as robot,
def.probe,
cb.met_description,
def.target, 
def.qos,
snap.samplevalue,
snap.sampletime,
def.r_table,
def.table_id,
def.probe
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, -24, getdate())
AND def.probe in ('processes')
--and robot like '%testmachine%'
order by def.target, def.probe asc