/build/static/layout/Breadcrumb_cap_w.png

Create Tickets Closed Report for K1000

I am trying to create a report that'll show me all the tickets I have closed within 48 hours of when I took possession of the ticket and tickets that I created as the owner and closed.

We, Desktop Support Techs, are required to close tickets within 48 hours of possession.  We have a report in place but I don't believe it's accurate.  I'm not very familiar with SQL but when I compare the report to what I have actually closed, it seems off.

The report is emailed every Wednesday and is supposed to be a weekly report from Wednesday, 12:00AM to Tuesday, 11:59PM.  It's supposed to shows how many tickets we have ownership of, total number of tickets we've closed as owners, and total number of tickets that were closed within 48 hours.  Then it expresses that as a percentage of tickets closed and tickets closed in 48 hours.

If you can create a new report that is more accurate I'll appreciate it.  My owner name, the way it's displayed on the report, is (De Santiago, Miguel A.)

0 Comments   [ + ] Show comments

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