RT data size maintenance

RT Users
1

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.

2

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

Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: 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, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael KuehneVon: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@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.

3

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 7015From: Brumm, Torsten / Kuehne + Nagel / Ham MI-ID [mailto:torsten.brumm@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-bounces@lists.bestpractical.com [mailto:rt-users-bounces@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.