Confirm device removal

book

Article ID: 108860

calendar_today

Updated On:

Products

CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration

Issue/Introduction

How can we confirm a device has been removed from CAPC?

Environment

Any CAPM environment

Resolution

  1. Connect to mysql on CAPC 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>/G';
    • The above query will tell us which data sources are contributing the device to CAPC.  Note the SourceID int he output
  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 (Administration > Monitored Items Management > Monitored Devices)
  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 now be gone