Best approach for bulk deleting unreferenced Software Models with no entitlements?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
Hi Team,
We have a requirement to bulk delete around 65k Software Models that appear to be safe cleanup candidates.
The deletion criteria is:
- Software Model has no entitlements
- Software Model has no references in any related/reference table
- Only models created by approved system/service accounts are in scope
Since Software Models can be referenced across multiple tables, we want to avoid direct bulk deletion and use a controlled, auditable approach.
The strategy we are considering is:
Identify safe delete candidates once
Run a read-only script to find Software Models with no entitlements and no references.Store candidates in a staging/control table
Store Software Model sys_id, display name, created by, created date, validation status, and backup data.Delete from the staging table in controlled batches
Process only records marked as safe/pending, using a configurable batch size.Track status per record
Mark each record as Pending, Deleted, Skipped, or Failed.Produce summary reporting
Report total scanned, safe candidates, deleted count, skipped count, failed count, and reference reasons.
This would make the cleanup resumable and auditable instead of manually running many individual batches.
Has anyone implemented a similar bulk Software Model cleanup?
Is this staging/control-table approach recommended, or is there a better/simple pattern for safely deleting a large volume of unreferenced Software Models?
