How can I run a query to get a list of the UIM robots?

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

How can I get a list of active or inactive robots from the UIM database?

Environment

• Any UIM Version

Resolution

The following query will be a good starting point:

SELECT nm.robot,cs.create_time AS COMPUTER_SYSTEM_CREATE_TIME,nm.check_time AS NIMBUS_ROBOT_CHECK_TIME, nm.hub from CM_COMPUTER_SYSTEM cs INNER JOIN CM_NIMBUS_ROBOT nm on nm.robot=cs.name 

You can add one of the following clauses:

--where create_time >= DATEADD(hh, -24, GETDATE())  -- uncomment this clause to get all robots that have been added in the last 24h 

--where check_time >= DATEADD(hh, -24, GETDATE()) -- OR uncomment this clause to get all robots that have checked in within 24h;  change the >= to <= to get those which have NOT checked in