Creating reports with Query Studio - Documentation for BMC Decision Support for Server Automation 8.7

This topic describes how to create reports using Query Studio. It includes the following sections:

To create reports using Query Studio

Note

BMC recommends that you create reports with the Preview with No data option. After previewing the report, apply the required filters and run the report with full data to get optimal performance.

1. Launch Query Studio from the BMC Decision Support for Server Automation portal.
2. Select a package (for example, BladeLogic) from the list of available packages.
   
   The following figure shows the report creation window with the default report template in the right panel and the domain folders in the left panel, based on the selected BladeLogic package. These domain folders contain query subjects and query subjects contain query items. You can use the query items to create reports.
   
3. Click the Run Report link.
4. Click the Preview with No Data link.
5. Click the Insert Data link.
6. To add a query item to the report, drag the query item from the corresponding domain folder onto the report template or double-click the query item.
7. Apply filters based on your requirements. For information about filtering, see Query Studio.
8. Click the Run Report link.
9. Click the Run with All Data link.
10. Save the report.

Related BMC Communites videos

The following BMC Communities video series provides examples of how to create reports using Query Studio. Part 1 shows how you can write your own Detailed Server Inventory report using Query Studio. Part 2 discusses how to convert queries to reports and scheduling using BMC Decision Support for Server Automation. Part 3 shows how to create a patching report.

 Writing your own reports - Detailed Server Inventory Report (Part 1) (5:51): 

 Writing your own reports - Converting Queries to Reports and Scheduling (Part 2) (2:51): 

 Writing your own reports - Patching Compliance Rate by Run (Part 3) (6:40): 

Related topics

Sample reports demonstrating Query Studio features
Domain-specific report examples