How to fetch all robots and installed probes from the database
search cancel

How to fetch all robots and installed probes from the database

book

Article ID: 280691

calendar_today

Updated On: 03-15-2024

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

You want to generate a report that would provide a list of everything you are monitoring within the hubs\robots and all the probes used.

Environment

DX UIM 20.4.x / 23.4.x

Resolution

You can run the following SQL command in your database: 

List all hubs and robots, and their deployed probes and probe versions and their OS within a specific time range

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