query to find robots without a certain probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Is there a query to find robots without a particular probe installed?

Environment

Release : 20.x

 

Resolution

The following query can be used, just substitute the appropriate probe name:

select * from cm_nimbus_robot where robot_id not in
(select distinct robot_id from cm_nimbus_probe where probe_name = 'probe_name_goes_here')