/build/static/layout/Breadcrumb_cap_w.png

K1000 report

Hello,

Could please any help me create report as time to create, time to close, technician ID, time to resolved (Duration) accordingly business hours and holidays.
Appreciate if any one help me on this.

Best Regards
Sasi

 

2 Comments   [ + ] Show comments
  • Just so I understand.

    time to create = Time the ticket was created
    time to close = How long the ticket was open
    technician ID = ticket owner
    time to resolved = Is this the same as "time to close"

    Can you elaborate on "accordingly business hours and holidays"?

    Are you able to describe in more detail how you would like to to look and when this report is to be sent or is it a on-demand report for the last x days? - smalls 8 years ago
    • 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.) - sasikaran 8 years ago
      • Ahhh. Ok I will see what I can come up with. - smalls 8 years ago
    • Well to get the Created Date, Closed Time, Tech are very easy and the wizard can do this. The Duration with the exclusion of weekends get tough for my limited SQL know how.

      I did find this:

      http://stackoverflow.com/questions/12753881/time-difference-between-dates-including-business-hour-and-excluding-holidays

      That might offer some help.

      Sorry I cant be more help. - smalls 8 years ago
  • I am very grateful for your time - sasikaran 8 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