Get mapping of device inventory and its producing probe and robot

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

sometimes decommissioned ip device still visible in USM and you don't know which robot / probe is source producing that device inventory data.

here is an example sql to get to know the map.

Environment

UIM ANY version

Resolution

Here is an example sql.

select a.origin, c.robot, a.name, b.probe_name, c.address from CM_COMPUTER_SYSTEM a
INNER JOIN CM_DEVICE b on b.cs_id = a.cs_id
INNER JOIN CM_NIMBUS_ROBOT c on c.dev_id = b.dev_src_id
ORDER BY origin,robot,name
 

Unfortunately, niscache based agent-less probes are displayed as "niscache"