[rt-users] shredding attachments based on date

[Jon 'Boli' Copeland]

you can shred based on sql query, such as

./rt-shredder --plugin "Tickets=query,Queue = 'Support' and Status =
'deleted';limit,5000" --sqldump /root/bup9.sql --force

...so you can change the query as you see fit.


On 19-Dec-16 2:38 PM, Andy Smith wrote:
>
> Hi all,
>
>   I'd like to remove attachments older than x months from the database
> and thought probably rt-shredder is the tool for this (its not
> something I've used before). Having googled this a bit and checked
> "rt-shredder --plugin help-Attachments" for instructions it looks like
> it may not be possible to use date, can anyone advise? Otherwise I
> guess I need to delete them directly from MySQL, not sure if this will
> make a mess of RT though,
>
> thanks for any help, Andy.
>
>  

-- 
Jon 'Boli' Copeland
Systems Engineer
IT Sales & Services Ltd
All sales enquiries   : sales at itss.co.tz
All support enquiries : support at itss.co.tz
Emergencies Only      : +255 (0) 685 374780