How can I get a list of active or inactive robots from the UIM database?
Any UIM Version
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 which have been added in the last 24h
--where check_time >= DATEADD(hh, -24, GETDATE()) -- OR uncomment this clause to get all robots which have checked in within 24h; change the >= to <= to get those which have NOT checked in