<div>Hi all, </div>
<div> </div>
<div>Thanks very much for your responses. I will have a look at the shredder extension. </div>
<div> </div>
<div>I just need to import my rt database into a temporary system before playing with this as I can't afford our ticketing to go down.</div>
<div> </div>
<div>In case of any issue with shredder I might have to try to just try the MySQL statements given on a test system and see what happens...</div>
<div> </div>
<div>Thanks again for your help,</div>
<div>Tim<br><br> </div>
<div><span class="gmail_quote">On 14/06/07, <b class="gmail_sendername">Jeff Stark</b> <<a href="mailto:JStark@sumtotalsystems.com">JStark@sumtotalsystems.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Thanks Jeff, we do have Shredder installed and it works great for<br>Tickets, etc...but you can't shred Attachments in Custom Fields with it,
<br>so we are left with shredding the ticket or dealing with the horrid<br>performance of the system with the large attachment...<br><br><br><br>Jeff Stark, Sr Systems Administrator<br>SumTotal Systems, Inc. (Nasdaq; SUMT)
<br><br><br>OFFICE +1 919 326 7548<br>MOBILE +1 919 622 0418<br><br>EMAIL <a href="mailto:jstark@sumtotalsystems.com">jstark@sumtotalsystems.com</a><br><br><br>The contents of this communication are considered SumTotal Confidential,
<br>and should not be shared with anyone outside of SumTotal, either<br>electronically or verbally, without the express permission of the<br>author(s).<br><br>-----Original Message-----<br>From: Jeff Platter [mailto:<a href="mailto:jplatter@vortexit.net">
jplatter@vortexit.net</a>]<br>Sent: Thursday, June 14, 2007 1:23 PM<br>To: Jeff Stark; 'Gene LeDuc'; 'Tim Hill'<br>Cc: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>
<br>Subject: RE: [rt-users] Delete large attachment<br><br>Hey you guys might want to try the RTx::Shredder extension. You can find<br>it on cpan:<br><a href="http://search.cpan.org/~ruz/RTx-Shredder-0.06/lib/RTx/Shredder.pm">
http://search.cpan.org/~ruz/RTx-Shredder-0.06/lib/RTx/Shredder.pm</a><br><br>I've installed it and used it before. It works great with tickets and<br>there is an option in there for attachments as well. There is a WebUI
<br>for it so you don't really need to mess with any SQL directly.<br><br>Just a thought. Hope it helps.<br>-Jeff<br><br>-----Original Message-----<br>From: <a href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com
</a><br>[mailto:<a href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>] On Behalf Of Jeff<br>Stark<br>Sent: Thursday, June 14, 2007 1:12 PM<br>To: Gene LeDuc; Tim Hill<br>Cc:
<a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>Subject: RE: [rt-users] Delete large attachment<br><br>Hi Gene,<br><br>What would you recommend for Custom Field Attachments? They are stored
<br>in the ObjectCustomFieldValues in the LargeContent field, correct?<br>Would you do the same for that table?<br><br>Thanks,<br><br>- Stark<br><br><br>The contents of this communication are considered SumTotal Confidential,
<br>and should not be shared with anyone outside of SumTotal, either<br>electronically or verbally, without the express permission of the<br>author(s).<br><br>-----Original Message-----<br>From: <a href="mailto:rt-users-bounces@lists.bestpractical.com">
rt-users-bounces@lists.bestpractical.com</a><br>[mailto:<a href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>] On Behalf Of Gene<br>LeDuc<br>Sent: Thursday, June 14, 2007 12:41 PM
<br>To: Tim Hill<br>Cc: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>Subject: Re: [rt-users] Delete large attachment<br><br>Hi Tim,<br><br>Best to try this on something harmless before assaulting your production
<br>database.<br><br>Disclaimer - I don't know anything about PostgreSQL other than it's a<br>database. I use MySQL, so my answer probably needs to be translated<br>from MySQL to PostgreSQL. I also use RT 3.6.3, so there might be schema
<br>differences as well.<br><br>Attachments are stored in the Attachments table. The contents are<br>stored in a column called Content. This column is a longtext (in<br>MySQL), meaning it can store up to 4GB.<br><br>If you were using MySQL, the following statement should replace all
<br>attachments greater than a certain size (4MB for example) with an<br>"Attachment deleted" statement. I have no idea what the syntax would be<br>using PostgreSQL.<br><br>UPDATE Attachments SET Content = 'Attachment deleted due to space
<br>constraints.', ContentType = 'text/plain', ContentEncoding = 'none'<br>WHERE<br>LENGTH(Content) > 4000000;<br><br>If you want to do it for specific tickets, you need to get the ticket<br>number indirectly. The Attachments:TransactionId column points to a
<br>Transactions record whose Transactions:ObjectId column contains the<br>ticket number.<br><br>Have fun and be careful out there!<br>Gene<br><br>At 04:42 AM 6/14/2007, Tim Hill wrote:<br>>Hi,<br>><br>>I have a member of staff who has decided to attach docuements to his
<br>>tickets in bitmap format, unfortunately these bitmap images are between<br><br>>4 and 8 MB in size and they have taken up more space in a day of doing<br>>this than the rest of the RT system has taken up in almost a year of
<br>operation.<br>><br>>I don't mind if the tickets have to be deleted, they can be recreated<br>>easily enough. How can I get rid of these attachments from the RT<br>>database? Where are the attachments stored and what are my options for
<br>>getting rid of them?<br>><br>>I am using the following:<br>>RT version 3.4.4 from an ubuntu package.<br>>Server version of dapper drake 6.06 LTS (webmin shows this as 6.06.1)<br>>Webmin version 1.320
PostgreSQL version 7.4.12 (With schemas)<br>><br>>Please let me know if you require any other information.<br>><br>>Thanks in advance,<br>>Tim<br><br><br>--<br>Gene LeDuc, GSEC<br>Security Analyst<br>San Diego State University
<br><br>_______________________________________________<br><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br><br>Community help:
<a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a> Commercial support:<br><a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
<br>Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br><br>_______________________________________________<br><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br><br>Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a> Commercial support:<br><a href="mailto:sales@bestpractical.com">
sales@bestpractical.com</a><br><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br><br>--<br>
This message has been scanned for viruses and dangerous content by<br>MailScanner, and is believed to be clean.<br><br><br><br>--<br>This message has been scanned for viruses and<br>dangerous content by MailScanner, and is
<br>believed to be clean.<br><br><br></blockquote></div><br>