Hello,@[deleted]I have modified this as below;SELECT ost_ticket.number AS "Ticket Number", ost_ticket__cdata.subject AS "Subject",ost_ticket.Source AS "Source",ost_user.name AS "Created By",ost_ticket.created AS "Ticket Opened", CONCAT(HOUR(TIMEDIFF(ost_ticket.created, ost_ticket.lastupdate)), ' Hours ', MINUTE(TIMEDIFF(ost_ticket.created, ost_ticket.lastupdate)), ' Minutes') AS "Created to Last Update time", CONCAT(ost_staff.firstname," ", ost_staff.lastname) AS "Agents Name", CONCAT("http://ostticket//scp/tickets.php?id=",ost_ticket.ticket_id) AS "Link" FROM ost_ticket LEFT JOIN ost_staff ON ost_ticket.staff_id=ost_staff.staff_id, ost_thread_entry, ost_user, ost_thread, ost_ticket__cdata WHERE ost_ticket.ticket_id=ost_thread.object_id AND ost_thread.id=ost_thread_entry.thread_id AND ost_ticket.ticket_id=ost_ticket__cdata.ticket_id AND ost_ticket.user_id=ost_user.id AND ost_ticket.created>='2018-05-07' AND ost_ticket.created<='2018-06-07' GROUP BY ost_ticket.ticket_id;Is there a way to find the time between a state change? As some get put on hold but would still mean we're within the SLA etc. Some have it where user emails, we reply and place on hold, they never respond and we close 2 days later. This leads to about 53 hours "created to last update".Regards(If someone else wants this SQL, it basically provides number, subject, source, created by user, opened time, created to last update, agent name and link.