How do i create a report that shows open tickets for one particular owner?
I have zero SQL skills and usually build reports using the wizard so i need some help with this. I need to create a report that shows all tickets that are not closed for a particular ticket owner, anything New, Reopened, etc.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
JordanNolan
5 years ago
You can use the report wizard to create the report. When the Wizard starts pick Service Desk for the Category and the Topic would be your service desk queue. Just walk through the steps of the report for the fields you want and when you get to the Filters section, just filter by:
Owner = Username
Status != Closed
It would be great if KACE allowed you to have a variable so you could run it on demand for a user, but I usually just end up running the report as an Excel file and using Excel to do my filtering.