Update on this. I found some old posts and I am trying to use the following
command to display tickets by size:
mysql -u root -p<mypasswd> -hlocalhost rt3 -e'select length(A.Content), A.id,
T.Ticket fromAttachments A, Transactions T where A.TransactionId = T.id order
by 1'
it returns:
"ERROR 1054 (42S22) at line 1: Unknown column 'T.Ticket' in 'field list'"
I am running RT 3.6.5. Can help would be greatly appreciated!
Thanks,
Shannon
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
