Deletion of cert_audit_result Contents - Cleanup done via gs.truncate('cert_audit_result') via KB1159151Issue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: block; max-width: ; width: auto; height: auto; } } The cert_audit_result table is taking a large chunk of size in the instances, currently at 1.619 TB in every instance, and needs to be deleted to free up database space. Customer followed https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1159151 using gs.truncateTable("cert_audit_result ") from background scripts NOTE the gs.truncateTable creates a temp table starting with z_xxx which will get removed via scheduled job 'Online Alter Truncate Delayed Drop Table' the next day! Sample of output from running the gs.truncate script: As a result of this the database footprint for the instance will not show any significant decrease until after the z_xxx table is removed. Once the table is removed it may take some time for the Database Footprint to show the decrease Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: block; max-width: ; width: auto; height: auto; } } Any Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: block; max-width: ; width: auto; height: auto; } } 1. Review the documentation on the cert_audit_result table and its deletion process. 2. Implement the gs.truncate command to delete the cert_audit_result table. 3. Wait for the job 'Online Alter Truncate Delayed Drop Table' the next day! 4. Wait for the database footprint to reflect the complete cleanup of the z_cert_audit_resultxxx table, which may take around 24 hours. 5. Monitor the instance usage to ensure the deletion has taken effect and the database space has been freed up.