/build/static/layout/Breadcrumb_cap_w.png

kace k1000 status timestamp report SQL

hey there

 

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?


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: fidzul.yahya@bagnetworks.com.bn 11 years ago
Senior Yellow Belt
1

i know that in k1000, we have time_opened, time created, time stalled, time closed, time modified and so on. but how to get those status time stamp?

Posted by: chucksteel 11 years ago
Red Belt
1

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.

 


Comments:
  • got it up and right. Not an exact fields i can get but theres a field where the timestamp when escalation ticket is send. can use that for that specific purpose.


    as for now, im using the unused custom field and ticket rule to update the field with timestamp when ticket is save and status is changed.

    thanks ;))

    p.s anobody able to get admin right to access and write into the dB? :D - fidzul.yahya@bagnetworks.com.bn 11 years ago
    • The only way you can make changes to the database is with a service desk rule. You can use the rules to make changes to almost any part of the database, though. - chucksteel 11 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ