Hopefully a couple simple SQL reporting requests.

Hello Ninjas, 

I am in dire need of some SQL assistance, I was tasked with creating the following "weekly" reports in KACE:
- Open tickets per week
- Closed tickers per week 
- Assigned tickets to user per week. 

I've played around with some SQL strings I've found online through message boards and GitHub but due to my very limited knowledge of SQL and the reporting Wizard I pretty much came out empty handed and was hoping someone could post a script they currently are using or could point me in the right direction. I greatly appreciate any assistance you guys are willing to give!

Thanks, Jon 

0 Comments   [ + ] Show comments

Answers (2)

Posted by: chucksteel 2 years ago
Red Belt
I keep a repository of queries here:

If you have checked those and they don't work, then it would be helpful to include details, such as, what columns do you want in the report, what specific criteria, etc. For instance, your first request is "Open tickets per week". Do you mean the number of tickets created in the past week and the report will be scheduled to run weekly? Do you want the report broken down by queues? Do you really just want a report that returns just a number? All of these details are needed in creating a report that will be meaningful for the person that requested the report.

  • So this is a goldmine. Thank you! - PFKurt 2 years ago
Posted by: ondrar 2 years ago
Black Belt
Does this get you what you need?
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