Hi There,
It has been a while since I have worked with RT… but I still love it.
I need to shred old tickets, tickets that have been closed for more than a year or two.
Why? Our RT database is now just over 115GB in size and mysql is not coping.
I don’t want to remove the tickets, I want to remove the transactions and attachments.
As I understand it, this will allow someone to still search for a ticket and find some metadata about the ticket - helping the user to find more information elsewhere about the issue.
I couldn’t work out how to do this. How do I use more than 1 plugin at a time?
Does anyone know how?
I look forward to your responses.
Thanks & Regards
Jens
Hi Jens,
I need to shred old tickets, tickets that have been closed for more than a
year or two.
Why? Our RT database is now just over 115GB in size and mysql is not
coping.
OK, thats not so big 
I don’t want to remove the tickets, I want to remove the transactions and
attachments.
We have a RT Addon from BPS which is not removing/deleting the Attachements
but stores them on disk instead of DB, this could work for you.
@BPS: When will the AttachmentOnDisk Addon available at Github?
As I understand it, this will allow someone to still search for a ticket
and find some metadata about the ticket - helping the user to find more
information elsewhere about the issue.
I couldn’t work out how to do this. How do I use more than 1 plugin at a
time?
Under RT 3.8? just add the second besides the first at the RT_SiteConfig.pm
Plugin Entry…?!?
Does anyone know how?
I look forward to your responses.
Thanks & Regards
Jens
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
MFG
Torsten Brumm
http://www.brumm.me
http://www.elektrofeld.de