/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: JordanNolan 5 years ago
10th Degree Black Belt
0

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.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ