/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Hopefully a couple simple SQL reporting requests.

08/30/2018 445 views
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

Comments



Community Chosen Answer

2
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.
Answered 08/31/2018 by: chucksteel
Red Belt

  • So this is a goldmine. Thank you!

All Answers

1
Does this get you what you need?
https://www.itninja.com/question/k1000-service-desk-report-of-tickets-created-per-week
Answered 08/30/2018 by: ondrar
Black Belt

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