<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!-- p { margin-top: 0px; margin-bottom: 0px; }--></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hello,<br>
</p>
<p><br>
</p>
<p>Sorry for not seeing this sooner, but I'll leave this for people wondering about the same in the future.<br>
</p>
<p>We have sucessfully deleted single attachments from a ticket using rt-shredder. Issue the command like this;<br>
</p>
<p>rt-shredder --plugin 'Objects=Attachment,<attachment-id>'<br>
</p>
<p><br>
</p>
<p>We use RT 4.2.8.<br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
Med vennlig hilsen,<br>
Thomas Oddsund<br>
SDS/USIT<br>
</div>
</div>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>Fra:</b> rt-users <rt-users-bounces@lists.bestpractical.com> på vegne av Ram <ram0502@gmail.com><br>
<b>Sendt:</b> 25. oktober 2016 01:45<br>
<b>Til:</b> rt-users<br>
<b>Emne:</b> Re: [rt-users] Deleting one attachment</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div><span style="font-size:12.8px">Inline..</span></div>
<div><span style="font-size:12.8px">> A user at work added an attachment that violates corporate policy to a</span><br style="font-size:12.8px">
<span style="font-size:12.8px">> ticket; the ticket itself is valid and must be kept. I need to delete the</span><br style="font-size:12.8px">
<span style="font-size:12.8px">> attachment. A quick look at the rt-shredder tool does not make it apparent</span><br style="font-size:12.8px">
<span style="font-size:12.8px">> to me how to do this with rt-shredder. I can readily do it editing the db in</span><br style="font-size:12.8px">
<span style="font-size:12.8px">> mysql but I'd rather use rt-shredder if it will do the job.</span><br style="font-size:12.8px">
<span style="font-size:12.8px">> any help?</span><br>
</div>
<div><br>
</div>
I'll be going with a direct DB edit which I'm documenting here for the next person. Since I just want to suppress the file and do not want to hide the fact that it existed. Here is what I did, be very careful! If you don't know SQL or you don't understand every
step below then find someone else to help you - this is the WRONG PATH for you:
<div><br>
<div>
<div>1 Get the attachment id of the attachment to remove (as of RT 4.4.1 it's the *second* number in the URL that displays the attachment).</div>
<div><br>
</div>
<div>2 Add a comment to the ticket indicating that you are deleting the offending attachment for policy violation (or whatever you motive).</div>
<div><br>
</div>
<div>3 Run this command to improve your odds of not messing up and deleting the wrong transaction:</div>
<div>> select id, Transactionid, MessageId, Subject, Filename, ContentType, ContentEncoding, Headers, Creator, Created from Attachments where id= ATTACHMENT_ID_FROM_STEP_1 \G</div>
<div><br>
</div>
<div>4 If that looks right to you then run this SQL against A TEST COPY OF YOUR DB to ensure you are killing the right attachment</div>
<div>> update Attachments set Content = NULL where id = ATTACHMENT_ID_FROM_STEP_1 limit 1;</div>
<div><br>
</div>
<div>5 Go look at the ticket in RT and ensure that you did indeed eliminate the offending attachment.</div>
<div><br>
</div>
<div>6 Repeat steps 3,4,5 in your production environment.</div>
<div><br>
</div>
<div>7 Do not call me if you shot yourself in the foot. No warranty expressed or implied!</div>
<div><br>
</div>
<div>If this isn't perfectly clear, hire Best Practical (<a href="https://bestpractical.com/">https://bestpractical.com/</a>) to do it for you.</div>
<div><br>
</div>
<div>cheers,</div>
<div><br>
</div>
<div>Ram</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>