get mapping of niscache based inventory and its source robot

Document created by Yu_Ishitani Employee on Apr 16, 2018
Version 1Show Document
  • View in full screen mode

sometimes decommissioned ip device still visible in USM and you don't know which robot holds that data.

here is sql example to get to know which robot is source.



select, c.robot, 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
where b.probe_name = 'niscache'



unfortunately, actual probe name predict is hard since probe_name is just categorized as "niscache".