/build/static/layout/Breadcrumb_cap_w.png

Helpdesk reports by Location

I have Custom 4: set to import the users Location under User Details. I need to run monthly reports on how many tickets have been opened by Location. I don't see any way in the Report Wizard to query off that Custom 4: field.

0 Comments   [ + ] Show comments

Answers (6)

Posted by: GillySpy 13 years ago
7th Degree Black Belt
0
That's expeted behaviour jmcelvoy. If you could post ( or search) in the reports forum what your SQL query is so far then there's a good chance someone on here can tweak it for you.
Posted by: airwolf 13 years ago
Red Belt
0
If you haven't already figured it out, the wizard for reporting is pretty much useless - it can't do table joins... among other things. I believe this is something KACE is working on and they hope to make more robust in a future release.

For the time being, you're going to have to become familiar with writing custom SQL queries.
Posted by: jmcelvoy 13 years ago
Second Degree Blue Belt
0
Is there a recommended site for learning SQL queries? I had never seen any SQL queries before getting the Kbox...so needless to say I have know clue where to begin in learning to understand and write them. A quick google search found http://www.sql-tutorial.net/, is that a reputable site for this stuff?
Posted by: airwolf 13 years ago
Red Belt
0
The KBOX uses MySQL 5.x. Your best resource is the official site. http://dev.mysql.com/doc/
Posted by: jmcelvoy 13 years ago
Second Degree Blue Belt
0
Thanks for the info and link. Looks like I have some research to do.
Posted by: airwolf 13 years ago
Red Belt
0
Take a look in the Reports forum here as well. There may be some reports that you can pick apart and learn how they work. There may also be a few you can just copy and paste directly if they meet your needs for a report.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
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