[rt-users] finding largest Attachments

[Ruslan U. Zakirov]

Dave Dennis wrote:
> Absolutely wonderful!  This is what I had needed.
> 
> Now I have a list of offending large ticket(s), and their corresponding
> Transaction.id .
> 
> What is my next step towards cleanup -- has anybody written/updated
> a script that takes ticket ID as input and follows the wiki procedure
> for removing everything from every required table?
RTx::Shredder is on CPAN and it can do it.
I prepare new release, but it dosn't contain major fixes.


> 
> Thanks folks, big help!!
> 
> 
> 
> +-------------------------
> + Dave Dennis
> + Seattle, WA
> + dmd at speakeasy.org
> + http://www.dmdennis.com
> +-------------------------
> 
> On Mon, 16 Aug 2004, Stephen Turner wrote:
> 
> 
>>I think you need to join with the Transactions table:
>>
>>select length(A.Content), A.id, T.Ticket  from Attachments A, Transactions T
>>where A.TransactionId = T.id order by 1
>>
>>Steve
>>
>>At Monday 8/16/2004 01:53 PM, Dave Dennis wrote:
>>
>>>Jesse,
>>>
>>>Thanks, that makes sense, except the output from Attachments.id
>>>is that same as the number of a ticket that one might search on
>>>through RT?
>>>
>>>
>>>Kind regards,
>>>
>>>+-------------------------
>>>+ Dave Dennis
>>>+ Seattle, WA
>>>+ dmd at speakeasy.org
>>>+ http://www.dmdennis.com
>>>+-------------------------
>>
>>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com