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 [email protected]
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