[rt-users] Time until first take

[David Ocana]

Hi,

I'm trying to get a report of the average time for the first owner 
change transaction in a ticket. Is there a way of achieving this using 
TicketSQL or would I have to use something external to RT to make a 
query to the database directly?

My idea is to grab all the 'owner change' type of transactions for a 
ticket keeping just the first one, and calculate the difference between 
this event and the 'created' time for the ticket.

Does this make any sense?

Thanks,
David