Remove device from Netops Inventory when contributed from multiple data sources

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

How do you remove a device from DX Netops Portal Inventory if it does not exist in monitored devices on the DX Netops Data Aggregator?

Removed device from Data Aggregator Monitored Devices Inventory. It remains in NetOps Portal Inventory and ends up being recreated in the Data Aggregator Monitored Devices Inventory. How can it be completed removed?

Environment

All supported DX NetOps Performance Management releases

Cause

Device is contributed to Portal Inventory from multiple data sources. If not removed from ALL Data Sources, it will continue to be added to the NetOps Inventory.

If the Data Aggregator is configured to receive inventory from the Portal it may return after being removed from the Data Aggregator Monitored Devices Inventory.

Items are not removed from the DX Netops Portal until no Data Source is contributing the device.

https://knowledge.broadcom.com/external/article?articleId=129721

Resolution

Use the following MySql query to identify what Data Sources are contributing the device to the Portal inventory.

1. Connect to MySql netqosportal database. Run (default path shown) the following command. Enter the password when prompted.
   • /opt/CA/MySql/bin/mysql -uroot -p netqosportal
2. Run the following command to list the devices. Replace <item_name> with the specific device name.
   • select a.SourceID,a.LocalID,a.ItemID,v6_ntoa(a.address),a.ItemName, b.consolename from dst_device a, data_sources2 b where a.sourceid=b.sourceid and itemname='<item_name>';
3. Review the output and delete the device from all Data Sources.