Re: [rt-users] Find ticket numbers of tickets with large attachments

2013-01-18 Thread Ruslan Zakirov
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 re...@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

Re: [rt-users] Find ticket numbers of tickets with large attachments

2013-01-16 Thread Ruslan Zakirov
Hi, Attachments.TransactionId = Transactions.id, Transactions.ObjectId = Tickets.id WHERE Transactions.ObjectType = 'RT::Ticket'. On Thu, Jan 17, 2013 at 12:08 AM, Remy van Elst re...@relst.nl wrote: Hello, I'm trying to find the ticket numbers of large attachments in my RT instance. It is

Re: [rt-users] Find ticket numbers of tickets with large attachments

2013-01-16 Thread Remy van Elst
Hy Rus, How would I apply the query you listed to the query I listed? I'm not sure how to combine the two. Op Jan 16, 2013, om 9:21 PM heeft Ruslan Zakirov r...@bestpractical.com het volgende geschreven: Hi, Attachments.TransactionId = Transactions.id, Transactions.ObjectId = Tickets.id