Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

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

  • Add filters
  • Create groups

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:
    SoftwareChangeTrackingSummary.gif

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*