How do I Bulk Delete & Update 1 Million Incident Records in Customers Production Environment ?

[Shaah]

A customer has requested the bulk deletion and bulk update of nearly one million Incident records in their live ServiceNow production instance. What platform-native tools, background processing mechanisms, and data-handling strategies would you evaluate to safely perform this operation without breaching performance thresholds, system limits, or governance controls?

[PankajK75582456]

Hi @Shaah ,

This is a really nice use case to use delete jobs to preview the cascade delete effect before it gets deleted.

The more safer approach would be to use archive and destroy rules, this will give you an staging table before all the data gets deleted from the instances. The archive rule will first move your targetted incidents to a ar_incident table and there it will reside unless it meets the duration specified in destroy rules. You have more flexibility here to include the related records as well when you are deleting an incident. 

E.g, an incident will have SLA, child Incidents, cmdb_ci , etc associated with it and going with given options is the best solution here.

If this helped you, please mark my answer as helpful and accepted.

Thanks,

Pankaj kumar

[adityahubli]

Hello @Shaah ,

If my approach helps you then mark it as helpful and accept as solution.

Regards,

Aditya,

Technical consultant