Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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!