[rt-users] RT data size maintenance

[Venkateswaran, Subbaraman]

Our requirements say that we should not ever delete historical RT tickets. So we would appreciate the best possible way to delete attachments of size > 1MB (for e.g.). Btw, we are running RT 3.6.4. Thanks for your time.
 

Thanks 
Subba Venkateswaran 
A&T - App Eng - SEG 
609 282 7015 

 

________________________________

From: Brumm, Torsten / Kuehne + Nagel / Ham MI-ID [mailto:torsten.brumm at Kuehne-Nagel.com] 
Sent: Thursday, July 30, 2009 9:59 AM
To: Venkateswaran, Subbaraman; rt-users at lists.bestpractical.com
Subject: AW: [rt-users] RT data size maintenance


Hi,
 
be very, very, very careful doing this on DB level, you should give RTx-Shredder a try, but touching the DB directly is not a good Idea!
 
Torsten



Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg, Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne 


________________________________

Von: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von Venkateswaran, Subbaraman
Gesendet: Donnerstag, 30. Juli 2009 14:18
An: rt-users at lists.bestpractical.com
Betreff: [rt-users] RT data size maintenance



Could someone please help with an approach to delete all attachments in RT database earlier than an year (or so)? We are max'ing out RT database size and would like to perform some cleanup. Or if there is a better way to do these type of maintenance, please do let us know. Appreciate your help.

Thanks 
Subba Venkateswaran 
A&T - App Eng - SEG 
609 282 7015 


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, copying or use of this message and any attachment is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and permanently delete it from your computer and destroy any printout thereof.


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, copying or use of this message and any attachment is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and permanently delete it from your computer and destroy any printout thereof.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090730/d5cd4001/attachment.htm>