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.

Creating a report with groups and sections

The following example demonstrates how to create a report that lists server capacity by OS type.

DomainReport nameFeatures used
InventoryServer capacity by OS
  • Group data
  • Create sections

To create a report with groups and sections

  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/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)
  7. Select the OS Name and OS Version columns and click Group on the toolbar.
  8. Double-click the Capacity (GB) column and enter Physical Storage Device: Capacity (GB) as the new name of the column.
  9. Double-click the Capacity (in GB) column and enter Physical Memory Device: Capacity (in GB) as the new name of the column.
  10. Select the OS Name column and click Section on the toolbar.
  11. Click the Run Report link.
  12. Click the Run with All Data link.
  13. On the Prompt page, select the required option (for information about options, see  Running an Inventory report).
  14. 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