Extract Duplicate CI's from CMDB

[Piyush]

Hello Experts,

I have a query as below : 

I want to extract all the Duplicate Ci's in the Table -(Cmdb_ci_cmp_resource), where in I want two attributes as duplicate  on one CI, for instance , say CI "A" has Display name and Object ID both similar to another CI "B".

Like the way above , I would like to extract the records in Bulk .
Can you please suggest How can I achieve this

Thanks

[Community Alums]

Hi @Piyush ,

Please refer to this KB : https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0869861

[SK Chand Basha]

Hi @Piyush 

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

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

Mark it Helpful and Accept Solution!! If this helps you to understand.