Duplicates at CA Performance Management for two Tenants

Products

• CA Performance Management
• Network Observability

Issue/Introduction

Recently upgraded entire NetOps from 21.2.6 to 22.2.2.  Since then have noticed that some tenants have duplicates. 
I can't find these by name using DA REST calls, so it's likely that these are only in NetOps Portal MySQL DB.

Environment

Release : 22.2

Resolution

• Click on the duplicated devices in PC Inventory - Devices and notice the 'ItemID' listed in the URL address bar - e.g. in this example the ItemID is '1972':  
  
  http://<NetOps Portal_host>:8181/pc/desktop/page?pg=d&DeviceID=1972
  
  
• Then log into the netqosportal DB in MySql:

cd /opt/CA/MySql/bin/

mysql -unetqos -p<password>
or
mysql -uroot -p<password>

• • • then type:
      
      mysql> use netqosportal
      
      
• and run the following query using the ItemID found in the URL above as the <ItemID from PC>:

mysql> select SourceID,LocalID,DomainID,ItemName from dst_device where ItemID = <ItemID from PC> 

Do this for both ItemIDs of duplicated device.

• and also this:

mysql> select * from dst_domain;
mysql> select * from t_tenant;

The result will show which Data Source(s) contributed the device to NetOps Portal through the sync process.

Contact Broadcom Support.