Hi everyone,
I'm trying to create a MySQL query that retrieves the status history of a ticket from the time it's created to the time it's closed. Unfortunately, the default export from osTicket does not include the full status change history for tickets.
Does anyone know how I can write a query to pull the ticket status history? Ideally, I'd like to see all the state transitions a ticket goes through, including the timestamps for each change.
Any help or pointers would be greatly appreciated. Thank you!
