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
Hello,
I'm trying to find the ticket numbers of large attachments in my RT
instance. It is RT 4.0.8 running on Ubuntu 12.04, and I'm the root user
for this search quest.
I've constructed the following MySQL query:
select t.ObjectID,i.Subject from Attachments i LEFT OUTER JOIN
Transactions t on
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 RT 4.0.8 running on Ubuntu 12.04, and I'm the root user
for this search quest