SQL query to run to extract robots with missing specific probes

Document ID : KB000074499
Last Modified Date : 18/05/2018
Show Technical Document Details
Introduction:



 
Question:
In environments with hundreds/thousands robots, it could be useful to know where a specific probe is NOT installed.
Environment:
UIM 8.5
Answer:
Considering, as example, to search for robots where the 'cdm' probe is not installed; the following query can be used:

SELECT DISTINCT A.domain, A.hub, A.robot FROM CM_NIMBUS_ROBOT A, CM_NIMBUS_PROBE B
WHERE A.robot_id NOT IN (SELECT B.robot_id FROM CM_NIMBUS_PROBE B WHERE probe_name = 'cdm')