Tech Tip:  Get mapping of device inventory and its producing probe and robot

Document created by Yu_Ishitani Employee on Apr 16, 2018Last modified by Yu_Ishitani Employee on Aug 22, 2018
Version 4Show Document
  • View in full screen mode

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.


select a.origin, c.robot,, 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" 

1 person found this helpful