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.
Report name | Features used |
---|---|
Change tracking information for disk space | Add filters |
To create a Change Tracking report with filters
- 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
- 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)
- Add a filter to the Available Space (GB) column as follows:
- Select the column and click Filter on the toolbar.
- In the Filter dialog box, click the arrow next to the Missing Values link.
- From the list, select the Leave out missing values option.
- Click OK.
- Click the Run Report link.
- Click the Run with All Data link.
- On the Prompt page, select the Show Snapshot Data (Change Tracking) option.
- Click OK.
- 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
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*