Confirm device removal

Document ID : KB000108860
Last Modified Date : 31/07/2018
Show Technical Document Details
How can we confirm a device has been removed from CAPC?
Any CAPM environment
  1. Connect to mysql and run: select SourceID,ConsoleName from data_sources2; 
    • This will help show the SourceID for each datasource
  2. Run: select SourceID,ItemName from dst_device where ItemName='<name of device>';
    • The above query will tell us which data sources are contributing the device to CAPC
  3. Delete the device from all data sources (other than the DA) that are contributing it.  For example, Spectrum, NFA, ADA - then sync the datasources
  4. Delete the device from "Monitored Devices" in CAPC
  5. Delete the IP from any discovery profiles so there will be no attempt to rediscover it
  6. After doing the above steps connect to mysql and run select SourceID,ItemName from dst_device where ItemName='<name of device>';  - The device should not be gone