Hello,
I have to produce two simple reports multiple times a day and at the moment I need to run a number of reports to be able to produce this.
Could you please provide a New Query Report sql script that will show the below details. I would also need to be able select amend the script easily to show either a date range, or Today; Yesterday; thisweek etc. To clarify Resolved should include:
Report 1 - By Technician
Agent |
Open Events |
# Open out of SLA |
# Logged |
# Total Resolved |
# Resolved in SLA |
# Total Closed |
Tech1 |
|
|
|
|
|
|
Tech2 |
|
|
|
|
|
|
Tech3 |
|
|
|
|
|
|
Tech4 |
|
|
|
|
|
|
Report 2 - By Date
Date |
Open Events |
# Open out of SLA |
# Logged |
# Total Resolved |
# Resolved in SLA |
# Total Closed |
dd/mm/yy |
|
|
|
|
|
|
dd/mm/yy |
|
|
|
|
|
|
dd/mm/yy |
|
|
|
|
|
|
dd/mm/yy |
|
|
|
|
|
|
Many thanks,
Lisa