Disable "Deleted Records" for a Table

Michael Kaufman
Giga Guru

We have certain tables that are filling up the Deleted Records [sys_audit_delete] table.


  • report_stats_executions
  • report_executions
  • wf_command
  • etc

We don't care about these tables in Deleted Records [sys_audit_delete] table.   They don't have "Audit" true in their dictionary records.   Is there a way to turn off recording these tables in "Deleted records"?


We are planning on turning on Table Rotations for Deleted Records [sys_audit_delete].   However it shouldn't be that big in the first place.


Mike

1 ACCEPTED SOLUTION

Anurag Tripathi
Mega Patron
Mega Patron

Hi Mike,



I think this is what you are looking for, its a system property



glide.db.audit.ignoreSpecifies the tables where the sys_audit_delete file is not updated when records are deleted.
  • Type: string - a comma separated list of tables
  • Location: System Property [sys_properties] table
-Anurag

View solution in original post

4 REPLIES 4

Anurag Tripathi
Mega Patron
Mega Patron

Hi Mike,



I think this is what you are looking for, its a system property



glide.db.audit.ignoreSpecifies the tables where the sys_audit_delete file is not updated when records are deleted.
  • Type: string - a comma separated list of tables
  • Location: System Property [sys_properties] table
-Anurag

If anyone find this as a solution, please be aware the system property is now:

glide.db.audit.ignore.delete

Thanks Mate, ill keep this in mind.

My reply there was 4 year old tho 😛

-Anurag

Yeah, it was mostly an update if anyone else (like me) found this as the only viable answer.
You did lead me in the right direction, though. 🙂