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)
Please log in to answer
Posted by:
chucksteel
5 years ago
I keep a repository of queries here:
https://github.com/csteelatgburg/K1000-Database-Queries
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.
Comments:
-
So this is a goldmine. Thank you! - PFKurt 5 years ago
Posted by:
ondrar
5 years ago
Does this get you what you need?
https://www.itninja.com/question/k1000-service-desk-report-of-tickets-created-per-week
