Remove large amount of duplicate CI's

Asmita7
Tera Expert

Hello friends,

 

I come across one question in one of the meeting.

 

If there are large amount of duplicates in CI class (>25000). What will be my approach to remove / remediate these duplicates ?

 

Please suggest a best approach for this.

 

Thanks,

Asmi

4 REPLIES 4

sanketmohit
Tera Contributor

Hi @Asmita7  please use the de - duplication task method   navigate to Configuration > Identification/Reconciliation > De-duplication Tasks.

 

Please accept my solution if it is helpful.

Hi @sanketmohit 

Thank you.

Will de-dup task approach good for 25000 CI's?

Community Alums
Not applicable

hi @Asmita7 
You have two options for deleting CIs from the CMDB:
1. Direct Deletion:
Confirm the CIs to be deleted and create a backup of these records.
Proceed with deletion using a background script or the de-duplication task remediator.
2. Archival Before Deletion:
Archive the CIs using CI Archive Rules, retaining them in the archive tables for 30 days or longer.
Delete the CIs from the archive once the retention period has passed.
ServiceNow Documentation Link : https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/administer/database-rotat...

Regards,
Srinija