<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RT data size maintenance</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3562" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=171245114-30072009><FONT face="Trebuchet MS"
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><FONT face="Trebuchet MS" size=2>Thanks</FONT></SPAN>
<BR><SPAN lang=en-us><FONT face="Trebuchet MS" size=2>Subba Venkateswaran
</FONT></SPAN><BR><SPAN lang=en-us><FONT face="Trebuchet MS" size=1>A&T -
App Eng - SEG</FONT></SPAN> <BR><SPAN lang=en-us><FONT face="Trebuchet MS"
size=1>609 282 7015</FONT></SPAN> </P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Brumm, Torsten / Kuehne + Nagel / Ham
MI-ID [mailto:torsten.brumm@Kuehne-Nagel.com] <BR><B>Sent:</B> Thursday, July
30, 2009 9:59 AM<BR><B>To:</B> Venkateswaran, Subbaraman;
rt-users@lists.bestpractical.com<BR><B>Subject:</B> AW: [rt-users] RT data size
maintenance<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=025345713-30072009><FONT face=Arial
color=#0000ff size=2>Hi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=025345713-30072009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=025345713-30072009><FONT face=Arial
color=#0000ff size=2>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!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=025345713-30072009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=025345713-30072009><FONT face=Arial
color=#0000ff size=2>Torsten</FONT></SPAN></DIV><BR><BR>
<P class=MsoBodyText><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Kühne +
Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Dirk
Blesius (Stellv.), Reiner <SPAN class=SpellE>Heiken</SPAN> (Stellv.), Bruno
Mang, Alfred <SPAN class=SpellE>Manke</SPAN>, Christian Marnetté (Stellv.), Mark
Reinhardt (Stellv.), Jens <SPAN class=SpellE>Wollesen</SPAN>, Rainer <SPAN
class=SpellE>Wunn</SPAN>, Sitz: Bremen, Registergericht: Bremen, HRA 21928,
<SPAN class=SpellE>USt-IdNr</SPAN>.: DE 812773878, Persönlich haftende
Gesellschaft: Kühne & Nagel A.G., Sitz: <SPAN
class=SpellE>Contern/Luxemburg</SPAN>, Geschäftsführender Verwaltungsrat:
Klaus-Michael Kühne <O:P></O:P></SPAN></P><BR>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Von:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>Im Auftrag von
</B>Venkateswaran, Subbaraman<BR><B>Gesendet:</B> Donnerstag, 30. Juli 2009
14:18<BR><B>An:</B> rt-users@lists.bestpractical.com<BR><B>Betreff:</B>
[rt-users] RT data size maintenance<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face="Trebuchet MS" size=2>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.</FONT></P>
<P><FONT face="Trebuchet MS" size=2>Thanks</FONT> <BR><FONT face="Trebuchet MS"
size=2>Subba Venkateswaran </FONT><BR><FONT face="Trebuchet MS" size=1>A&T -
App Eng - SEG</FONT> <BR><FONT face="Trebuchet MS" size=1>609 282 7015</FONT>
</P><BR>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.<BR></BODY></HTML>
<br>
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.<br>