Remove large amount of duplicate CI's

Asmita7
Tera Expert

‎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

0 Helpfuls
  • 786 Views
4 REPLIES 4

sanketmohit
Tera Contributor

‎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.

0 Helpfuls

Asmita7
Tera Expert
In response to sanketmohit

‎12-24-2024 02:39 AM

Hi @sanketmohit 

Thank you.

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

0 Helpfuls

Community Alums
Not applicable

‎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

0 Helpfuls