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

[Niranjan Danda]

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.

[Punit S]

Hi Nirnajan,

There can be multiple causes of this issue, check your discovery configurations also you may want to check to OOB discovery business rule that are modified or updated for any customization etc..

Most possible reason is a business rule is modified and running   update/insert on each discovery scheduled without checking unique conditions.

What you could do is create a new field called "Name2" (u_name2) on the appropriate table(s), after finding a right business rule and select the Unique check box to enforce uniqueness on that field. Then, create a Business Rule that copies the Name field to the new field and the system will automatically enforce the uniqueness:

1. Name: Sync names  
2. Table: Server [cmdb_ci_server]  
3. Order: 10000000  
4. When: before  
5. Insert: Checked  
6. Update: Checked  
7. Script:  
8. (function(){  
9.       current.u_name2 = current.name;  
10. })();  

Thanks,

Punit

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

[Punit S]

Hi Niranjan,

Hope you are doing good.

Request your feedback on above answers ..

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

Thanks,

Punit