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 Inventory report with summarization, chart, and property

This example demonstrates how to create an Inventory report that shows how servers are distributed in different locations across an organization. To retrieve the location of a server, you add a property, Location, in BMC Server Automation. You assign a default value to this property and change its value in the BMC Decision Support for Server Automation environment, if required.

Report name

Features used

Server distribution by data center location

  • Summarize data
  • Create a chart
  • Add a property

To create an Inventory report with summarization, chart, and property

  1. Launch Query Studio from the BMC Decision Support for Server Automation portal.
  2. Select a package from the list of available packages (for example, BladeLogic).
  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:
    • Inventory Server Property/Location
    • Server/OS Name
    • Server/Server Name
  7. Select the OS Name column and click Group on the toolbar.
  8. Apply the Count function to the Server Name column with no summary for footers.
  9. Rename the Server Name column to the Server Count column.
  10. Create a column chart.
  11. Click the Run Report link.
  12. Click the Run with All Data link.
  13. Save the report.
     The following figure shows a sample Inventory report created by using this procedure:
    ServerDistributionbyDataCenter.gif

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*