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.
Procurement and Purchase
and so on...so basically each process, the status will have the timestamp on the comment for the ticket. how to retrieve those timestamp?