Any solution available to remediate CI duplicates in bulk?

[Suggy]

We have around 100k duplicate CI's. We want to do like this - consider the recent udpated record as master record and clean our the other records.

I know that this is possible in de-duplication workflow, but as we have huge records, looking for alternate solution for mass updates with above logic. Is it possible?

[SK Chand Basha]

Hi @Suggy 

I'm not sure about this refer the below link for Reference

https://www.servicenow.com/community/cmdb-forum/duplicate-ci-remediation-in-bulk/td-p/2705962

[Suggy]

Thanks @SK Chand Basha  Let me dig into that.

[Mark Manders]

Do you know the cause of these duplications? Reason for asking: if the cause (like automated imports) isn't taken away, any cleanup will end up useless, because they will be created again.

You could mimic the outcome of the de-duplication workflow through script, based on your conditions, but I never tried that myself.

[Suggy]

@Mark Manders  Yes we know the root case, and fixed them as well. Now looking for options for bulk remediation.