query the list of packages on each robot

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Need a database query that can list the packages that are installed on each robot.

Environment

DX UIM - Any Version

Resolution

The probes and packages which are installed on each robot can be gathered by the discovery_server and populated into the database tables CM_NIMBUS_PROBE and CM_NIMBUS_PACKAGE.

This functionality is not enabled by default and can be enabled by following this article.

Once this has been enabled, allow at least 24 hours for discovery_server to fully populate the data.

Once the data is populated, you can query these tables for probe and package details.

Example queries

Query the list of packages, versions, and time installed on all robots:

select r.robot,r.hub,r.ip,n.name,n.version,n.install_time from cm_nimbus_robot r
left join cm_nimbus_package n
on r.robot_id = n.robot_id;

Query the list of probes (excluding non-probe configuration packages) on all robots:

select r.robot,r.hub,r.ip,p.probe_name,p.pkg_version from cm_nimbus_robot r
left join cm_nimbus_probe p
on r.robot_id = p.robot_id;