UIM Database query to filter based of OS type and Probes

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We need a UIM Database query to filter based on robot OS type and installed probes.

Environment

Release: 20.x or higher

Resolution

Please run the query below:

select robot.hub,robot.robot,robot.ip,robot.robot_active,robot.check_time,robot.alive_time,robot.os_major,os_minor,package.probe_name,

package.pkg_version,ccs.create_time,ccs.change_time from cm_nimbus_probe package

join cm_nimbus_robot robot on package.robot_id = robot.robot_id

join CM_COMPUTER_SYSTEM ccs on robot.ip = ccs.ip

ORDER BY ccs. create_time