[rt-users] Time until first take

David Ocana docana at ebi.ac.uk
Mon Jun 8 07:13:00 EDT 2015


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?


More information about the rt-users mailing list