it is not recommended to delete records on "sys_audit" table , i want to delete the old logs of some attributes.

shabbir5
Tera Guru

it is not recommended to delete records on "sys_audit" table ?, i want to delete the old logs of some attributes.

what happens if i run the background script or fix script to perform this operation

@Ankur Bawiskar 

Thank you,

Shabbir

7 REPLIES 7

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

what's your exact requirement?

Why to delete records from sys_audit? It might help in auditing in later stage.

check this

Demystifying table rotation, extension, and table cleaner

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

HI Ankur ,

The requirement is to delete audit logs(old) of 2 attributes.

Thank you,

Shabbir

check this

Delete or Update Activity log and Journal Field Entries

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

I was notified by ServiceNow PDI support that my PDI is too big and that I must "truncate" the database within 48 hours. The sys_audit table is the largest and contains records as old as April 22, 2015!