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

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

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.
Answered 01/06/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
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.
Answered 01/06/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
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?
Answered 01/06/2011 by: jmcelvoy
Second Degree Blue Belt

Please log in to comment
0
The KBOX uses MySQL 5.x. Your best resource is the official site. http://dev.mysql.com/doc/
Answered 01/06/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Thanks for the info and link. Looks like I have some research to do.
Answered 01/06/2011 by: jmcelvoy
Second Degree Blue Belt

Please log in to comment
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.
Answered 01/06/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity