[rt-users] finding largest Attachments

[Ray Walters]

Try this :

mysql -e'select length(a.Content), t.ticket from Attachments as a join 
Transactions as t on a.transactionid=t.id' |sort -n


Dave Dennis wrote:

> Sorry to bother you all,  what I guess is happening is
> the database is using "TransactionID" and I'm flailing about
> trying to connect that back to a ticket number.
> 
> Whats needed is a good way to identify jesse's output back to
> ticket number. The wiki shows generic examples, but specific
> would be useful.
> 
> will keep trying / post something if I figure it out on my own.
> 
> Thanks again.
> 
> 
> +-------------------------
> + Dave Dennis
> + Seattle, WA
> + dmd at speakeasy.org
> + http://www.dmdennis.com
> +-------------------------
> 
> On Mon, 16 Aug 2004, 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
>>+-------------------------
>>
>>On Mon, 16 Aug 2004, Jesse Vincent wrote:
>>
>>
>>>
>>>
>>>On Mon, Aug 16, 2004 at 10:10:57AM -0700, Dave Dennis wrote:
>>>
>>>>Hey folks,
>>>>
>>>>Anyone have a query to run that shows tickets (Attachments) in physical
>>>>size from largest to smallest?
>>>
>>>mysql -e'select length(Content), id from Attachments' |sort -n
>>>
>>>
>>>
>>>>Thanks,
>>>>
>>>>Dave D
>>>>
>>>>+-------------------------
>>>>+ 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
>>>>
>>>
>>>--
>>>
>>
>>_______________________________________________
>>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>>Be sure to check out the RT wiki at http://wiki.bestpractical.com
>>
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com
>