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.br...@kuehne-nagel.com] Sent: Thursday, July 30, 2009 9:59 AM To: Venkateswaran, Subbaraman; rt-users@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-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Venkateswaran, Subbaraman Gesendet: Donnerstag, 30. Juli 2009 14:18 An: rt-users@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.
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com