CA Infrastructure ManagementCA Performance Management - Usage and AdministrationDX NetOps
Issue/Introduction
How can we confirm a device has been removed from NetOps Portal?
Environment
Dx NetOps Performance Management any version
Resolution
Connect to mysql on NetOps Portal and run: select SourceID,ConsoleName from data_sources2;
This will help show the SourceID for each datasource
Run: select SourceID,ItemName,v6_ntoa(address) from dst_device where ItemName='<name of device>/G'; or select SourceID,ItemID,ItemName,v6_ntoa(address) from dst_device where itemname like '<name of device>%';
The above query will tell us which data sources are contributing the device to NetOps Portal. Note the SourceID int he output
Delete the device from all data sources (other than the DA) that are contributing it. For example, Spectrum, NFA, ADA - then sync the datasources
Delete the device from "Monitored Devices" in NetOps Portal (Administration > Monitored Items Management > Monitored Devices)
Delete the IP from any discovery profiles so there will be no attempt to rediscover it
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