04/05/2019 248 views
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


All Answers


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.

Answered 04/07/2019 by: JordanNolan
Seventh Degree Black Belt