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

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

Answers (2)

Posted by: Hobbsy 7 years ago
Red Belt
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.
Posted by: grayematter 7 years ago
5th Degree Black Belt
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

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