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.
Report name | Features used |
---|---|
Software change tracking summary on servers |
|
To create a Change Tracking report with filters and groups
- Launch Query Studio from the BMC Decision Support for Server Automation portal.
- Select a package (for example, BladeLogic) from the list of available packages.
- Click the Run Report link.
- Click the Preview with No Data link.
- Click the Insert Data link.
- 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
- 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.
- Group the report by the Server Name column.
- Group the report by the Software Type column.
- Apply the filter on the Change Type column with the Added, Modified, and Removed filter values selected.
- When you are prompted to combine the filter conditions, click OK.
- Create a bar chart that plots the Server Name and Software Type columns against the Added, Modified, and Removed columns.
- Click the Run Report link.
- Click the Run with All Data link.
- 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
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*