Remove large amount of duplicate CI's
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-23-2024 10:11 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-23-2024 10:21 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 02:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 03:55 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 06:07 AM - edited 12-24-2024 06:07 AM
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