We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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

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  ||  ✨ 10x 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  ||  ✨ 10x 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!