Identify and delete duplicate CIs

[basava]

Hello Geeks,

I have a requirement where in for each CMDB Class we need to identify and delete the duplicate CIs. We have nearly 900K records in CMDB.

Can you please let me know the best way to identify the duplicate CIs and delete them?

Thanks in advance!!!!

[Yashsvi]

Hi @basava,

please check below link:

https://www.servicenow.com/community/itom-articles/servicenow-duplicate-cis-solution-script-report/t...

Thank you, please make helpful if you accept the solution.

[Harish Bainsla]

Hi @basava please use below link 

https://www.servicenow.com/community/itsm-forum/script-adjustment-delete-duplicate-cis/td-p/630552

https://www.servicenow.com/community/developer-forum/remove-duplicate-ci/m-p/2725651

https://www.servicenow.com/community/cmdb-forum/duplicate-ci-cleanup-in-cmdb/m-p/225681