Deleted records table

[vktripper]

I am trying to understand the workings of the Delete Records table under System Definition. What kind of records make it to this table? Let's say I delete a user from the sys_user table - this action would essentially transfer this user record to this table. But if there is a deletion from the task_ci table (because a CI is no longer affected by a change request), does this also make an entry into the deleted records table?  Ar records purged from this table at some point and if so, do I have any sort of control over this process?

[Paul Curwen · Accepted solution]

Hi vktripper,

Not all record deletions are tracked. On a table with attribute 'no_audit_delete=true', deletions will not be tracked. Also Deletions from tables with a 'sys' prefix i.e. 'sys_user' are not audited by default. If you want to track deletions from these tables, just add the table name to the 'glide.ui.audit_deleted_tables' system property. For full details of how to do this see:

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/system-logs/task/t...

Note that for records that are deleted, any related attachments are NOT restored. Also records with images DO NOT WORK with this. 

The retention policy is 7 days, so you need to undelete anything within this timescales or it's gone. 

Hope that helps

Regards,

Paul