[rt-users] finding largest Attachments

[Dave Dennis]

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