kace k1000 status timestamp report SQL

im looking for a way to get the timestamp for each of status in my ticket. I have at least 8 status and my client looking for a report that can show how long does a ticket status stays until it escalate to another status.

example

New

Opened

Review

quotation

Procurement and Purchase

Delivery

and so on...so basically each process, the status will have the timestamp on the comment for the ticket. how to retrieve those timestamp?

I don't have a full answer for you but I can say that you would need to look at the HD_TICKET_CHANGE_FIELD and the HD_TICKET_CHANGE tables. Do you have MySQL Workbench or another tool setup to allow you to look at the database? If not I would recomment doing that. This will probably require some in depth SQL work to get a report like the one you are looking for.