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,