DX Infrastructure Management

  • Private Community
 View Only
Back to Library

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

Apr 16, 2018 07:47 AM

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, 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" 

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Yu Ishitani
Aug 21, 2018 09:34 PM

Hi, Daniel. Thank you very much for valuable feedback. I have incorporated your tip into the contents. Thank you again.

Richard Little
Aug 21, 2018 11:46 AM

These are from the application discovery feature in USM

 

Daniel Blanco
Aug 21, 2018 11:10 AM

Any idea what are these entries from:

probe_name
app_disco.app_disco_apache
app_disco.app_disco_iis_server
app_disco.app_disco_mysql
app_disco.app_disco_oracle
app_disco.app_disco_sqlserver

Daniel Blanco
Aug 21, 2018 11:06 AM

Thanks!

Changed it so its ordered:

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

 

Related Entries and Links

No Related Resource entered.