tickets concluded report

tickets concluded report

Good day to everyone,

I need some help in creating a custom query, we need to have a complete report o concluded tickets.

Example:

the various columns:

  • Request ID
  • Subject
  • Request Type
  • Request Status
  • Overdue Status
  • Created Time
  • Created By
  • Request Mode
  • Level Priority
  • Impact
  • Urgency
  • Category
  • Sub Category
  • Item Region
  • Department
  • Requester
  • Workstation
  • Group
  • Technician
  • Time Spent(in Hours)
  • Time Spent(in days)
  • Dueby Time
  • Completed Time
  • Responded Date
  • Resolved Time
  • completed time - Created Time
  • Resolved Time - Created Time
  • completed time - Dueby Time
  • completed time - Resolved Time
  • Time Elapsed
  • SLA Description
  • SLA Violation
-----------------------------------------------------------------------------------------------------------------------------
  • We need to know the difference between completed time and due date and SLA violation.
  • We should be able to filter  the query by Resolved date or/and Completed date or/and Technician 
Conclusion:

We would like to launch every week a report of all the tickets resolved or/and completed during a specific week, we would like to keep track of any SLA violation. We should be able to run this report eventually every month and annual.

Thank you in advance,