Scripting Question

report requests

01/06/2016 979 views

could please any one help me to create report as time to create, time to resolved, technician ID, time to respond (duration) considered Business hours and holidays.

time to create = Time the ticket was created
time to resolved = Time the ticket was resolved (in progress to resolved time )
technician ID = ticket owner
time to respond = How long was taken to resolve the ticket, this should be considered only business hours and holidays. e.g ( business hours Sunday - Thursday 8.30-17.30, time to create Sunday 16.30, time to resolved Monday 9.30, time to respond should be 0day, 2 hours, 00 min.)

Best Regards
1 Comment   [ + ] Show comment


  • This gets difficult to create unless you have service desk rules in place that will change the state of the ticket based on business hours and holidays. If you have that in place and the tickets move into a stalled state when no one is working you should be able to calculate the total time a ticket was in an open state. Otherwise I'm honestly not sure how you would perform the required math in the SQL statement.

Be the first to answer this question

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