Creating Service Desk Reports: Last X days by Location, Top Problem Users
As I'm getting used to using the service desk, I'm also trying to create the reports my upper management will want. I can already do reports for Open tickets by Owner, Closed tickets last 7 days by Owner, ect.
What I'm trying to figure out is how to show:
1: How many tickets opened the last 7 days by location
2: How many tickets opened the last 7 days by Affected User
What I would really like if possible is who are the top 5 problem usere over the last 7 days. Meaning what are the top 5 users that had the most tickets opened for them over the last 7 days.
Any help would be most appreciated.
Try this one for your location report, break the report on your location field
WHERE (HD_TICKET.HD_QUEUE_ID = X) AND
(((TIMESTAMP(HD_TICKET.CREATED) <= NOW() AND TIMESTAMP(HD_TICKET.CREATED) > DATE_SUB(NOW(),INTERVAL 7 DAY))))
ORDER BY CUSTOM_FIELD_VALUE0