How do I delete a device from Performance Management

Document ID : KB000036208
Last Modified Date : 08/01/2019
Show Technical Document Details
Introduction:
Sometimes, there are  issues deleting elements from the inventory which was originally synced from CA Spectrum for one or more tenants. This may occur due to network problems or server down when a device was being updated and disrupting the synchronisation between the data source and CAPC. In these situations, to delete a device requires investigation in the dst_device table of CAPC's MySQL (netqosportal) DB to check the data source from which it came.
Question:
How do I delete a device from Performance Management?
Environment:
CAPM 3.x
Answer:
If you delete a device from the Data Aggregator but it still shows up in the inventory you can do the following:

1. On the CA Performance Center machine, run; 
 
/opt/CA/MySql/bin/mysql -uroot -p<PASSWORD> netqosportal

If you're getting Access Denied for user root, then follow the instructions in the docops;
2. Run the following command: 
 
select a.*, b.consolename from dst_device a, data_sources2 b where a.sourceid=b.sourceid and itemname='<item_name>'\G;

For example;

select a.*, b.consolename from dst_device a, data_sources2 b where a.sourceid=b.sourceid and itemname='cis2524'\G

The output will look something like this:
*************************** 1. row ***************************
                   SourceID: 6
                    LocalID: 0x100093
            ItemSubTypeName: router
                     ItemID: 358
                ItemSubType: 1
                  UpdatedOn: 1452014190
                    Address:           DomainID: 3
                   ItemDesc: Cisco Internetwork Operating System Software   IOS (tm) 2500 Software (C2500-I-L), Version 12.1(27b), RELEASE SOFTWARE (fc1)  Copyright (c) 1986-2005 by cisco Systems, Inc.  Compiled Tue 16-Aug-05 22:38 by pwade
                   ItemName: cis2524
             LifeCycleState: active
                   SnmpRead: NULL
                 SnmpReadID: NULL
                SnmpVersion: NULL
                  SnmpWrite: NULL
                SnmpWriteID: NULL
                      Alias: NULL
              AlternateName: NULL
                    Contact: NULL
                DisplayName: NULL
            ItemMemberFlags: NULL
LifeCycleStateLastChangedOn: NULL
                   Location: NULL
                      Model: NULL
                  SystemOID: NULL
                     Vendor: NULL
                consolename: Spectrum Infrastructure Manager@IM1

3. Based on this we know the device was added to Performance Management through the Spectrum / Performance Center Integration.  To get rid of the device in Spectrum you would need to either delete it from Spectrum or remove it from the appropriate "IP Domain" collection from within Spectrum.  Then do a resynch of the data source.  This should remove the device from Performance Management
Additional Information:
What is outlined above is simply an example for Spectrum as the data source.  Similar rules would apply if the consolename (data source) was ADA, NFA etc.  The data source noted is the source of truth for where a device comes from, so it would need to be removed from the data source before we see it disappear from CA Performance Management