Report needed to List all active robots without an specific probe.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Need a list of those robots in IM without a certain probe, for example cdm.

A use case would be an administrator that needs to know if there are any robots missing some required probe (not considering MCS here).

Environment

Any DX UIM version

 

Cause

There is no such report OOTB.

The IM shows only the active robots, so the query must consider the following:

1- Only active robots are displayed in IM 

2- Robots without a certain probe are those that have no current metrics 

Resolution

For SQLServer:

select * from CM_NIMBUS_ROBOT
where domain = 'enter domain'
and alive_time >= DATEADD(DAY, -10, GETDATE())
and robot not in 
(
select distinct robot from s_qos_data where table_id  in (
select table_id from S_QOS_SNAPSHOT where table_id in (
select table_id from s_qos_data where probe = 'cdm')
and sampletime >= DATEADD(DAY, -10, GETDATE())
)
)

 

For Oracle:

select robot, origin, domain from CM_NIMBUS_ROBOT
where domain = 'enter domain'
and alive_time >= (SYSDATE -10)
and robot not in 
(
  select distinct robot from s_qos_data where table_id  in 
    (
    select table_id from S_QOS_SNAPSHOT where  sampletime >= (SYSDATE -10) and table_id in 
       (
       select table_id from s_qos_data where probe = 'cdm'
       ) 
    )
)

Additional Information

The queries above will retrieve all robots that have been active for the last 10 days, i.e. have sent metrics, but not for the specified probe, in this example, cdm.

Any combination of domain, time frame, and probe can be used in the query.