"cmdb_ip_address_dns_name" table showing Duplicate IP address attached to ci's.

Niranjan Danda
Tera Contributor

Hello

When i checked DNS name of a CI it have multiple Duplicated IP address Attached to it. Can i know is this normal to exist such duplicated IP address for a DNS name of a server.

If it is abnormal can anyone please let me know any way to overcome such duplicates in that table.

Thanks,

Niranjan.

6 REPLIES 6

Punit S
Giga Guru

Yes, it is possible for multiple hostnames to use the same ip address, the best practice is to use a CNAME record to point to the A record


bar.example.com.               CNAME   foo.example.com. foo.example.com.               A           192.0.2.23 

Hope this helps.


Thanks,


Punit


Hello Punit,



Thanks for the quick Response!



My concern is the host name has one IP address and the IP address is listed multiple times. I thing it creates every time when discovery runs and deletes the previous one. But it is not deleting the previous one and creating a new one instead.



find_real_file.png



Thanks,


Niranjan.


Punit S
Giga Guru

Hi Niranjan,



I get your situation now, your understanding is correct. I would suggest to check the cmdb_ci_ip_address table   for duplicate IP's discovered possibly every time scheduled discovery occurs. Also check the discovery log for any duplicate IP information. If the issue is recurrent you may find hundreds of duplicate IP entries grouped by each DNS.



Thanks,


Punit



Hit like, Helpful, Correct and Endorse, if it answers your question.


Hi Punit,


Thanks for your response.



Is there any reason why it is creating duplicates and is there any way to stop creating such duplicates. Please let me know how to resolve that issue.



Thanks,


Niranjan.