Sample Change Tracking report with filters

This example demonstrates how to create a Change Tracking report that lists the changes that occurred in disk space over a period of time.

To create a Change Tracking report with filters

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
   • Snapshot Job/Job Run Start Time
   • Common/Hardware Information/Hardware/Storage Devices/Physical Storage Device/Capacity (GB)
   • Common/Hardware Information/Hardware/Storage Devices/Physical Storage Device/Available Space (GB)
   • Common/Hardware Information/Hardware/Storage Devices/Physical Storage Device/Used Space (GB)
7. Add a filter to the Available Space (GB) column as follows:
   1. Select the column and click Filter on the toolbar.
   2. In the Filter dialog box, click the arrow next to the Missing Values link.
   3. From the list, select the Leave out missing values option.
   4. Click OK.
8. Click the Run Report link.
9. Click the Run with All Data link.
10. On the Prompt page, select the Show Snapshot Data (Change Tracking) option.
11. Click OK.
12. Save the report.
    The following figure shows a sample Change Tracking information report created by using this proecdure:
    

Related topics

Sample reports demonstrating Query Studio features
Creating reports with Query Studio