[rt-users] finding largest Attachments

[Jesse Vincent]

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
> 

--