Hello, I would like to delete attachments from tickets older than 5 years. I don't know how to do this. I'm using RT 5. If there is no solution to simply delete attachments, is it possible to completely delete tickets and attachments older than 5 years? Thank you
Hi @Florent , check rt-shredder - RT 5.0.8 Documentation - Best Practical and searching in this forum you’ll find examples and other FAQs about this tool.
+1 shredder. some practical considerations:
- Do a dry run first to validate your query / results.
- Don’t do a huge volume of shredding in one go. Start with a small number (for example maybe 100 tickets) and see how long that takes / impact on production. Then ramp up until you find a threshold that allows you to iterate through it without killing your system.
- You can script it - definitely recommended if you are intending to shred a lot of stuff.
- You can get it to generate a backup sql & objects store as part of the shredding. If you need to retain things for XX years this is a way of facilitating this, whilst not bloating your db too much.
- Different types of objects are faster / slower to shred (for example tickets & attachments - slow, users - fast).
- There are some helpful notes in the link posted above around Indexes / database tuning considerations
1 Like