My boss emailed me today asking if, by Monday, i could produce the following reports.
Average time from Open to Resolve on an Incident.
Average time from Resolve to Close on an Incident
Number of tickets for each employee
Number of closed tickets
Number of Open Tickets
5 oldest tickets
Where do i even begin ? Does anyone here have reports like these ? Are these reports something that is taken care of in SQL ? Should i use a query or a report to collect this data ? Anyone have any ideas ?