Best way to cleanup sys_audit

Rashmi Bansal
Mega Guru

I wanted to know if there is any way to cleanup safely sys_audit data from the multiple shards

2 REPLIES 2

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

Have you already undertaken any actions? Or inventarisation of what to cleanup? Or is your question just about how literally to safely delete without stressing the instance?

 

I am currently writing a series on the Database Footprint which might interest you (still some blogs in draft). Amongst others about sys_audit.
- 2024-01-24 - Blog - Keeping your instance database footprint tidy (08): Maintain Email 
- 2024-01-09 - Blog - Keeping your instance database footprint tidy (07): Cleanup Shadow tables 
- 2023-11-29 - Blog - Keeping your instance database footprint tidy (06): Drop syslog_trans_prejakarta* tables

- 2023-11-13 - Blog - Keeping your instance database footprint tidy (05): Lower duration Table Rotation
- 2023-10-02 - Blog - Keeping your instance database footprint tidy (04): Reduce (over)Auditing

- 2023-08-01 - Blog - Keeping your instance database footprint tidy (03): Activating/adding Table cleaners 
- 2023-07-05 - Blog - Keeping your instance database footprint tidy (02): Maintain Attachments and Attachment Documents
- 2023-06-13 - Blog - Keeping your instance database footprint tidy (01): Maintain Audit Delete and Audit Relation

 

If Sys Audit is on Table extension (which you are seeing your question on shards), then do note if deleting on shards themselves:
https://www.linkedin.com/feed/update/urn:li:activity:7178718621982953472/

 

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

JoelatNow
ServiceNow Employee
ServiceNow Employee

@Mark Roethof - I'm liking your blogs; these two are access restricted. Would you refresh or enable?
- 2023-07-05 - Blog - Keeping your instance database footprint tidy (02): Maintain Attachments and Attachment Documents
- 2023-06-13 - Blog - Keeping your instance database footprint tidy (01): Maintain Audit Delete and Audit Relation