How to know which servers are monitored and generating QOS metrics and which are not in UIM?

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

How to know which servers are monitored and providing metrics and which are not?

Environment

• Release: 20.4, 23.4
• Component: UIM OPERATOR CONSOLE - INVENTORY

Resolution

UIM 23.4 CU3 and above
Monitoring Governance provides comprehensive and transparent information about individual devices or groups.
In the OC->Inventory, then select a device or group-> then select Monitoring Governance


Screenshot example below:

- For detailed information about the robots with monitoring probes run the below queries on the database:

--This returns the listing of all devices that are reporting metric data: 

select 
cs.name 
, ci.ci_name 
,sd.robot 
,cs.create_time 
,cs.change_time 
,cs.alive_time 
, cb.met_description 
, ci.ci_id, ci.dev_id 
, cd.probe_name 
,sd.probe 
,sd.qos 
, cm.ci_metric_id 
, sd.table_id 
, sd.r_table 
, sd.h_table 
, sd.v_table 
from cm_configuration_item ci 
join cm_device cd on cd.dev_id=ci.dev_id 
join cm_computer_system cs on cs.cs_id=cd.cs_id 
join cm_configuration_item_metric cm on cm.ci_id=ci.ci_id 
join cm_configuration_item_metric_definition cb on cm.ci_metric_type=cb.met_type 
join s_qos_data sd on sd.ci_metric_id=cm.ci_metric_id
order by alive_time desc

--This gets the listing of all those devices that are NOT reporting current metric data:

select 
cs.name 
, ci.ci_name 
,sd.robot 
,cs.create_time 
,cs.change_time 
,cs.alive_time 
, cb.met_description 
, ci.ci_id, ci.dev_id 
, cd.probe_name 
,sd.probe 
,sd.qos 
, cm.ci_metric_id 
, sd.table_id 
, sd.r_table 
, sd.h_table 
, sd.v_table 

from cm_configuration_item ci 
join cm_device cd on cd.dev_id=ci.dev_id 
join cm_computer_system cs on cs.cs_id=cd.cs_id 
join cm_configuration_item_metric cm on cm.ci_id=ci.ci_id 
join cm_configuration_item_metric_definition cb on cm.ci_metric_type=cb.met_type 
join s_qos_data sd on sd.ci_metric_id=cm.ci_metric_id 

where 
alive_time < dateadd(day, -1, getdate())
--and sd.probe ='cdm' 
--and sd.source like 'machinename%' 
--and cs.alive_time < '2025-06-01' 
--where cs.name = 'machinename' order by table_id 
order by alive_time desc

Additional Information

Another possible reason why the 'Monitored by' column for a given device doesn't show the hub, robot, or monitoring probe is that it is blacklisted in cm_blacklist_computer_system table.

Search for it in the table using-> select * from cm_blacklist_computer_system