Verfy if robots have basic probes deployed on them

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Is there a way to check if the robots in the environment have basic probes like CDM, logmon, etc. deployed on them?

Is there a query to pull this information easily from the DX UIM DB? 

Environment

• DX UIM 23.4.*
• MS SQL DB

 

Cause

Guidance

Resolution

This information can be easily pulled directly from the DB:

 

--The following query shows all robots with 'ROBOTS WITH cdm, logmon, processes,ntevl,ntservices' probe installed in it.
--The condition the robot must meet to show up here in this list is that  the robot contains ALL probes listed in the query:
-- he "HAVING COUNT.." line must be equal to the number of probes listed. In the example below they are 5, so this line should be equals to 5. If checking 2 probes for example (cdm, logmon) equals this to 2. 

SELECT cm_nimbus_robot.robot as 'ROBOTS WITH cdm, logmon, processes, ntevl, ntservices'
FROM cm_nimbus_probe
INNER JOIN cm_nimbus_robot
  ON cm_nimbus_robot.robot_id = cm_nimbus_probe.robot_id
WHERE cm_nimbus_probe.probe_name  IN ('cdm', 'logmon', 'processes','ntevl','ntservices')
GROUP BY cm_nimbus_probe.robot_id, cm_nimbus_robot.robot
HAVING COUNT(DISTINCT cm_nimbus_probe.probe_name) = 5;

 

--The following query shows a list of servers where CDM i NOT INSTALLED:

SELECT cm_nimbus_robot.robot as 'ROBOTS WITH NO CDM INSTALLED'
FROM cm_nimbus_robot
WHERE NOT EXISTS (
    SELECT 1
    FROM cm_nimbus_probe
    WHERE cm_nimbus_probe.robot_id = cm_nimbus_robot.robot_id
      AND cm_nimbus_probe.probe_name = 'CDM'
);

 

You can run these queries in SLM > Query Editor, or in the DB Directly. 

Create a new Dashboard Designer (The Dashboard Designer) and use these queries as datasource for SQL Table Widget.