Sample Change Tracking report with filters and groups

The following example demonstrates how to create a Change Tracking summary report that shows a summary of the software changes that occurred on servers for the latest job runs.

To create a Change Tracking report with filters and groups

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.
3. Click the Run Report link.
4. Click the Preview with No Data link.
5. Click the Insert Data link.
6. Open the Inventory folder and drag the following query items to the right pane:
   • Server/Server Name
   • Common/Software/Software Type
   • Common/Software/Software Type/Change Tracking/Change Type
   • Common/Software/Software Type/Change Tracking/Added
   • Common/Software/Software Type/Change Tracking/Modified
   • Common/Software/Software Type/Change Tracking/Removed
7. Open the Inventory/Filters folder and drag the Snapshot Job Latest Run filter to the right pane to obtain data only for the latest job runs.
8. Group the report by the Server Name column.
9. Group the report by the Software Type column.
10. Apply the filter on the Change Type column with the Added, Modified, and Removed filter values selected.
11. When you are prompted to combine the filter conditions, click OK.
12. Create a bar chart that plots the Server Name and Software Type columns against the Added, Modified, and Removed columns.
13. Click the Run Report link.
14. Click the Run with All Data link.
15. Save the report.
    The following figure shows a sample Change Tracking summary report created by using this procedure:
    

Related topic

Sample reports demonstrating Query Studio features
Creating reports with Query Studio