The wizard looks easy but I never get exactly what I need. Are there any documents that instruct users how to create reports?

thanks,
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
Take a look at the administrative guide in the support section of the KBOX. You may also want to browse through the knowledgebase.

I hardly ever use the wizard, as it cannot join tables. This means you can only report on data from a single table - which is almost useless in my environment. You must write your own SQL, for instance, if you want to find machines with a specific piece of software installed. However, I believe I remember someone from KACE stating that the wizard will be modified to allow table joins in a future release.
Answered 01/13/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Some of the IT's here that are nott SQL savey, and don't want to learn it use the report wizard. You can at least make some reports with it, like computers with certain software, or what not but not very useful ones. If I remember correctly, like the filters it doesn't give you the option to use ID's, just names. I used it at first then quickly realized how basic it was and switched to SQL.
Answered 01/13/2010 by: dtuttle
Purple Belt

Please log in to comment
0
like computers with certain software

You can't even do that with the wizard since you can't join the MACHINE table to the SOFTWARE table. I believe you can do this to a limited extent, but the software title listed on the report is messed up. It's been a while since I've tinkered with the wizard, but I use SQL for everything. I'd rather learn SQL (which is what I did) than deal with the wizard.
Answered 01/13/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
You can't even do that with the wizard since you can't join the MACHINE table to the SOFTWARE table. I believe you can do this to a limited extent, but the software title listed on the report is messed up.

You can. I can't upload a picture of it, but under other there is a software titles... But its useless for us because I have been doing alot of computer/software reports on computers running old versions of software. With the report builder you cant do that if both software have the same name. It wont query version number of software ID (not like you can just edit the sql.
Answered 01/13/2010 by: dtuttle
Purple Belt

Please log in to comment
0
Right, that's it - you cannot check for software details such as version. You can list machines with "X Software" installed, but you can't pull any info related to the title. That's why it's useless to us - we have to make sure the latest version is installed, so we do a lot of reporting on multiple versions of the same software title.
Answered 01/13/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
What is a good report generating program for the Kbox MySQL database? Kbox does use MySql correct?
Answered 01/15/2010 by: chipdisk
Senior Yellow Belt

Please log in to comment
0
What is a good report generating program for the Kbox MySQL database? Kbox does use MySql correct?

Yes, but the version of MySQL depends upon whether you are running an older 32-bit KBOX or one of the newer 64-bit KBOX's. The 32-bit boxes are still running MySQL 4.x, and the newer 64-bit boxes are running MySQL 5.x. As far as reporting goes, you can use the R1 account to remotely access the database with read-only rights. You can use any reporting mechanism you'd like such as Microsoft Excel (using ODBC), Crystal Reports, etc.
Answered 01/15/2010 by: airwolf
Tenth Degree Black Belt

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