How can i get the list of all robots which is added into HUB recently (last week) earlier
Any UIM Version
SELECT nm.robot,cs.create_time AS COMPUTER_SYSYEM_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 where create_time >= DATEADD(hh, -24, GETDATE())