[rt-users] finding largest Attachments

[Dave Dennis]

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?

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
> >+-------------------------
>
>