Duplicate devices in the same IP Domain

Products

• Network Observability
• CA Performance Management

Issue/Introduction

We see the same device twice in the same IP domain coming from different data sources.

The primary IP address of each device is different.

Environment

Release : 22.2, 23.3

Component : PM Discovery

Cause

If the primary ip address of the discovered device does not appear in the IP Address table of the other existing device and the hostnames do not match then the devices will not reconcile.

We can get the list if ip addresses synced by the different data sources.

1) Log into the mysql database on the Netops Portal:

/opt/CA/MySql/bin/mysql netqosportal -u netqos -p

Enter the password when prompted.

2) Get the data source SourceIDs:

select SourceID,ConsoleName,ConsoleHost from data_sources2;

This will help identify the data sources providing the device in dst_device.

3) Get the localid of each device:

select ItemID,LocalID,SourceID,ItemName,inet6_ntoa(address) from dst_device where itemname = '<DEVICENAME>'

Note the LocalID,  and IP address values.  The IP listed is the primary IP of the device as synced from the data source it is synced from.

4) Get the list of IP addresses synced from each data source by using the localid in the query below:

select v6_ntoa(address) from dst_address where localid in (select childlocalid from ds_item_members where childitemtype = 7 and parentlocalid in (select childlocalid from ds_item_members where childitemtype = 6 and parentlocalid = '<localid>')) order by 1

If you dont see the primary IP of the device in the list of IP addresses from the other data source and vice versa, this is the issue.

5) To exit the mysql prompt:

exit

 

Resolution

Use the same primary IP address for the device on all data sources.