How to delete a device

Document ID : KB000112988
Last Modified Date : 04/09/2018
Show Technical Document Details
Introduction:
How do you remove a device from inventory if it does not exist in monitored devices?
Environment:
Any CAPM environment
Instructions:
If the environment has other data sources you must identify what data source that
is contributing the device and delete it from that data source, or data sources
  • Connect to mysql netqosportal database
  • Run the following command:¬†select a.SourceID,a.LocalID,a.ItemID,v6_ntoa(a.address),a.ItemName, b.consolename from dst_device a, data_sources2 b where a.sourceid=b.sourceid and itemname='<item name>';
    • The above query will tell you the data sources contributing the device
  • From there, delete the device(s) from the data sources and allow sync to happen.¬†
The above steps will clean up the devices in question from the inventory