If Serial Number is empty and name is same then why duplicates are getting created

[Riya25]

Hello Experts,

Recently we have a issue in which  duplicate CI's are getting created having the Serial Number Empty but Name is same.

As per the identification when Serial Number is empty it should have checked for the Name Identifier then why duplicates are being created instead of updating the same record?

Also,after discovering the duplicates Class is different than the class of existing CI and IP address is same also in the  Created By field name of user is occurring.

Please help!! 

Regards,

Riya

[Azim Kazi · Accepted solution]

Hi Riya,

Can you please help which field we should consider other than serial number ,name to make a new Identifier rule especially for server table.

👉  You can use IP address attribute to create record uniquely or you can make asset tag as well if server is physical.

And also to delete the duplicates we should run the background script on individual table or base table (cmdb_ci) 

👉 I suggest you to delete by individual class and check if it working fine or not it won't take much time.

whether deleting will automatically delete the their respective Relationships or not ?

👉 Yes,it will delete relationship as well.

Regards,

Ajim.

[Azim Kazi]

Hi Riya,

It would be great if you mark my responses helpful whichever you found helpful and also mark correct If my response satisfactory.😊 

Regards,
Ajim.