Data stored in sys_audit_delete table

[nguyen duy]

Hi Team,

Currently, I want to get deleted records from the sys_audit_delete table and I have 3 questions as follows:
   - How long does the sys_audit_delete table store deleted records?
   - Can I get deleted records of 6 months, 1 year, or 2 years ago? And if possible, how?
Many thanks for all your contributions to my question.
Hoping to get an answer soon.

Thanks,

Duy Nguyen.

[Jaspal Singh]

Did you check for article by ServiceNow. It has answers to all your questions.

[nguyen duy]

Hi Jaspal, 

I checked that post but it's not clear to me.

I don't know if 28 days is the maximum number of days that ServiceNow will store deleted records or not ?

Or is there a table that can hold more than that number of days?

Or can I intervene to change 28 days to some other date?

Thanks,

Duy Nguyen

[Jaspal Singh]

So, it goes as below

28 days - is backup of complete instance as monthly backup. When a record is deleted from instance it will stay for 28 days in backup instance as original record & will be removed once it a fresh monthly backup is stored.

Deleted Records does not have the limit which implies even after deletion record will stay in Deleted Reocrds table but will not have any relationships. So, you might find an option to Undelete Record after 7 or 28 days still but it will not bring any relationships as it had before when you Undelete the records.

[Jaspal Singh]

In case of doubts still you can approach ServiceNow for the same.