https://www.servicenow.com/community/sam-forum/best-approach-for-bulk-deleting-unreferenced-software-models/m-p/3564231#M21188 <DIV><P>Hi Team,</P><P>We have a requirement to bulk delete around <STRONG>65k Software Models</STRONG> that appear to be safe cleanup candidates.</P><P>The deletion criteria is:</P><UL><LI>Software Model has <STRONG>no entitlements</STRONG></LI><LI>Software Model has <STRONG>no references in any related/reference table</STRONG></LI><LI>Only models created by approved system/service accounts are in scope</LI></UL><P>Since Software Models can be referenced across multiple tables, we want to avoid direct bulk deletion and use a controlled, auditable approach.</P><P>The strategy we are considering is:</P><OL><LI><P><STRONG>Identify safe delete candidates once</STRONG><BR />Run a read-only script to find Software Models with no entitlements and no references.</P></LI><LI><P><STRONG>Store candidates in a staging/control table</STRONG><BR />Store Software Model sys_id, display name, created by, created date, validation status, and backup data.</P></LI><LI><P><STRONG>Delete from the staging table in controlled batches</STRONG><BR />Process only records marked as safe/pending, using a configurable batch size.</P></LI><LI><P><STRONG>Track status per record</STRONG><BR />Mark each record as Pending, Deleted, Skipped, or Failed.</P></LI><LI><P><STRONG>Produce summary reporting</STRONG><BR />Report total scanned, safe candidates, deleted count, skipped count, failed count, and reference reasons.</P></LI></OL><P>This would make the cleanup resumable and auditable instead of manually running many individual batches.</P><P>Has anyone implemented a similar bulk Software Model cleanup?<BR />Is this staging/control-table approach recommended, or is there a better/simple pattern for safely deleting a large volume of unreferenced Software Models?</P></DIV> Thu, 25 Jun 2026 03:03:57 GMT pavan Punna 2026-06-25T03:03:57Z https://www.servicenow.com/community/sam-forum/best-approach-for-bulk-deleting-unreferenced-software-models/m-p/3564231#M21188 <DIV><P>Hi Team,</P><P>We have a requirement to bulk delete around <STRONG>65k Software Models</STRONG> that appear to be safe cleanup candidates.</P><P>The deletion criteria is:</P><UL><LI>Software Model has <STRONG>no entitlements</STRONG></LI><LI>Software Model has <STRONG>no references in any related/reference table</STRONG></LI><LI>Only models created by approved system/service accounts are in scope</LI></UL><P>Since Software Models can be referenced across multiple tables, we want to avoid direct bulk deletion and use a controlled, auditable approach.</P><P>The strategy we are considering is:</P><OL><LI><P><STRONG>Identify safe delete candidates once</STRONG><BR />Run a read-only script to find Software Models with no entitlements and no references.</P></LI><LI><P><STRONG>Store candidates in a staging/control table</STRONG><BR />Store Software Model sys_id, display name, created by, created date, validation status, and backup data.</P></LI><LI><P><STRONG>Delete from the staging table in controlled batches</STRONG><BR />Process only records marked as safe/pending, using a configurable batch size.</P></LI><LI><P><STRONG>Track status per record</STRONG><BR />Mark each record as Pending, Deleted, Skipped, or Failed.</P></LI><LI><P><STRONG>Produce summary reporting</STRONG><BR />Report total scanned, safe candidates, deleted count, skipped count, failed count, and reference reasons.</P></LI></OL><P>This would make the cleanup resumable and auditable instead of manually running many individual batches.</P><P>Has anyone implemented a similar bulk Software Model cleanup?<BR />Is this staging/control-table approach recommended, or is there a better/simple pattern for safely deleting a large volume of unreferenced Software Models?</P></DIV> Thu, 25 Jun 2026 03:03:57 GMT https://www.servicenow.com/community/sam-forum/best-approach-for-bulk-deleting-unreferenced-software-models/m-p/3564231#M21188 pavan Punna 2026-06-25T03:03:57Z