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

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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

Environment

Release : 20.3, 20.4

Component : UIM OPERATOR CONSOLE - INVENTORY

Resolution

On OC>Inventory, you can see the devices with monitoring probes that are active will have those probes populated on the Monitored by column if the robot has no monitoring probe then the Monitored by column will be empty.
Screenshot 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 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 
,rn09.table_id 'rnTableId' 
, sd.r_table 
, sd.h_table 
, sd.v_table 
into #tempNotNull 
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 
left outer join RN_QOS_DATA_0053 rn09 on sd.table_id=rn09.table_id 
--where cs.name = 'machine_name' order by table_id 
where 
rn09.table_id is not null 
and 
sd.r_table='RN_QOS_DATA_0009' 
--and sd.source like 'machine%' 
and sd.probe ='cdm' 
--and cs.alive_time < '2017-06-01' 
and rn09.sampletime >'2017-06-07' 

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 
,rn09.table_id 'rnTableId' 
, sd.r_table 
, sd.h_table 
, sd.v_table 
into #tempNull 
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 
left outer join RN_QOS_DATA_0009 rn09 on sd.table_id=rn09.table_id 
--where cs.name = 'machinename' order by table_id 
where 
rn09.table_id is null 
and 
sd.r_table='RN_QOS_DATA_0053' 
--and sd.source like 'machine%' 
and sd.probe ='cdm' 
--and cs.alive_time < '2017-06-01' 
--and rn09.sampletime >'2017-06-07' 

This will validate the two above queries: 

select * from #tempNull nu 
left outer join #tempNotNull notNu on nu.table_id=notnu.table_id 
where notnu.table_id is null