/build/static/layout/Breadcrumb_cap_w.png

Kace Average ticket time

Hello I need to create an SQL report that shows the average time spent on tickets per quarter. 

3 Comments   [ + ] Show comments
  • Can you define "spent on tickets" for your environment? Do you want the difference between when the ticket was created and when it was closed (the last time)? Do you track work hours in the service desk and you want the average of work performed? - chucksteel 7 years ago
  • As the my man Chuck says, you need to define what value you require and also make sure that it is recorded within each ticket before you can then consider writing a report that will calculate the average. If it is just the difference between Opened and Closed you could create a ticket rule to store the elapsed time in a custom field. - Hobbsy 7 years ago
  • Or you could use one of the new ServiceDesk widgets 7.2, if the default ones are targeting the correct queue - Hobbsy 7 years ago

Answers (0)

Be the first to answer this question

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