[rt-users] Find ticket numbers of tickets with large attachments
Ruslan Zakirov
ruz at bestpractical.com
Fri Jan 18 07:36:03 EST 2013
Hi,
I hoped you will do some leg work and figure this out.
On Thu, Jan 17, 2013 at 5:35 PM, Remy van Elst <relst at relst.nl> wrote:
> Hy Rus,
>
> Tried some more stuff, now it is working. Thanks!
>
> The Query:
>
> mysql> SELECT DISTINCT Transactions.ObjectId,Attachments.Subject FROM
> Attachments LEFT OUTER JOIN Transactions ON Transactions.Id =
> Attachments.TransactionId WHERE Transactions.ObjectType = 'RT::Ticket'
> AND LENGTH(Attachments.Content) > 4000000;
>
> Written it down for other people who might have the same problem:
>
> https://raymii.org/s/tutorials/RT_find__and_delete_big_attachments.html
>
> Sincerely,
--
Best regards, Ruslan.
More information about the rt-users
mailing list