Delete Duplicate records of CI's(computer)

[Service now11]

Hi,

I need to delete duplicates of cmdb_ci_computer. It is having large number of records. But The difficult part is I don't know the unique column to identify. Because the name of the CI having many serial numbers, IP address etc...As the name also it has many records. I am not sure about the correlation ID. The correlation ID may be unique. So I need the column i.e Install Status should not retired. So Kindly help on this and provide me a solution.

Thanks.

[Dhananjay Pawar]

Hi,

CMDB dashboard will give you the duplicates records and from there you can remediate the duplicate records.

Thanks,

Dhananjay.

[Sohail Khilji]

Hi @Service now11 ,

Refer my article which will help :

ServiceNow Duplicate CIs Solution / Script / Report