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

Riya25 · ‎05-07-2020

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 · ‎05-11-2020

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.

View solution in original post

Riya25 · ‎05-07-2020

Hello jaspal,

Just wanted to confirm when we do manual import identifiers doesn't work on them .Right?

According to the coalensed fields records are inserted in the table.

Regards,

Riya

Azim Kazi · ‎05-07-2020

coalesce does not work for discovery or integration that's why identifier concept is there in servicenow

Riya25 · ‎05-07-2020

Hello Anil, Then if we do manual import of CI's then how can we avoid duplicates? If Identifiers are used for manual import also then in this case why name identifier does not Worked it should have worked and should update the same CI rather than creating a new one. Can you please explain this. Regards, Riya

Riya25 · ‎05-07-2020

Sorry Ajim*

Vishwa Prakash · ‎05-07-2020

Hi Riya,

I have found something on community related to your requirement. Please go through the below links.

https://community.servicenow.com/community?id=community_blog&sys_id=3efc66a5dbd0dbc01dcaf3231f96193b

https://community.servicenow.com/community?id=community_question&sys_id=e5b08765db98dbc01dcaf3231f96...

Hope this helps. Please mark my answer correct and helpful.

Thanks