Creating a report with groups and sections
The following example demonstrates how to create a report that lists server capacity by OS type.
Domain | Report name | Features used |
---|---|---|
Inventory | Server capacity by OS |
|
To create a report with groups and sections
- 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/OS Name
- Server/OS Version
- Server/Server Name
- Common/Hardware Information/Hardware/Processor/Max Speed (MHz)
- Common/Hardware Information/Hardware/Storage Devices/Physical Storage Device/Capacity (GB)
- Common/Hardware Information/Hardware/Memory/Physical Memory Device/Capacity (in GB)
- Select the OS Name and OS Version columns and click Group on the toolbar.
- Double-click the Capacity (GB) column and enter Physical Storage Device: Capacity (GB) as the new name of the column.
- Double-click the Capacity (in GB) column and enter Physical Memory Device: Capacity (in GB) as the new name of the column.
- Select the OS Name column and click Section on the toolbar.
- Click the Run Report link.
- Click the Run with All Data link.
- On the Prompt page, select the required option (for information about options, see Running an Inventory report).
- Save the report.
The following figure shows a sample report, which is created by using the preceding steps:
Related topics
Query Studio
Creating reports with Query Studio
Domain-specific report examples
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.