KACE Product Support Question

How do I create a report that has all the assets that i select in it?

08/08/2016 866 views
When I create a report with the wizard i can only select 1 of the assets in the drop down menu.  I would like to create a report that has multiple assets in it.  Im not very SQL savvy and I could use a little help
0 Comments   [ + ] Show comments


Community Chosen Answer

Alternatively you can create a view in the Asset section using an advance search that contains the assets that you want, then from the choose action menu select the Create a Report option. Once the report is saved view the SQL.
Answered 08/09/2016 by: Hobbsy
Red Belt

All Answers

This can be done in SQL, but it is easiest if you create the parts in the wizard and stitch them together later.  Note that when you do this, each of the sub queries has to have the same number of columns.  Once you have the sub queries, you can UNION them together.  More info on the UNION syntax is available here:  http://dev.mysql.com/doc/refman/5.7/en/union.html
Answered 08/08/2016 by: grayematter
5th Degree 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


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