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?

[Matthew_13]

For ~1M incidents, the safest approach is to use batched scheduled scripts or APIs with precise filters, throttling, logging, and backups. Test in non-prod first, monitor performance, and ensure proper governance and approvals before running in production.

@Shaah - Please mark as Accepted Solution and Thumbs Up if you found Helpful!!

[adityahubli]

Hello @Shaah ,

For bulk record deleting there is OOTB option that is Data management .

 Go to target table => filter out data which you want to delete ( apply OOTB filter functionality) =>Right click => In Context Menu => click on Data management => Delete with delete preview  => cascade preview => execute now ( from related links) => wait filtered out records will get deleted

For updating records you have to use Code only with proper filter condition, logging and backup .

 Try this if only necessary .

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

Regards,

Aditya,

Technical Consultant

[adityahubli]

Hello @Shaah ,

You can also update bulk records by Data management without code also .

Go to target table => filter out data which you want to delete ( apply OOTB filter functionality) =>Right click => In Context Menu => click on Data management => click on Update with all preview => open another forms, enter the fields value which you want to update => save form => then there is execute now related link , click it => All filtered out records will get updated.

 Try this if only necessary .

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

Regards,

Aditya,

Technical Consultant

[Matthew_13]

@Shaah Hopefully we be able to help you my friend?