How can i get the list of all robots which is added into HUB recently - last 24 hours - Query

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

How can i get the list of all robots which is added into HUB recently (last week) earlier

Environment

Any UIM Version

Resolution

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())