How to know which servers are monitored and providing metrics and which are not?
In the OC->Inventory, you can see the devices with monitoring probes that are active will have those probes populated on the "Monitored by" column but if the robot has no monitoring probe then the Monitored by column will be empty.
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 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
Another reason why the 'Monitored by' column for a given device doesnt 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