Sample Inventory report with sorting and calculations

This example demonstrates how to create an Inventory report that shows the health of agents on the servers in your organization. Agent health includes agent version and status on a server. 

• To create an Inventory report and apply sorting and calculations (video)
• To create an Inventory report and apply sorting and calculations (text)
• Related topics

To create an Inventory report and apply sorting and calculations (video)

Watch this video to see how to create an Inventory report and apply calculations.

To create an Inventory report and apply sorting and calculations (text)

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

   • Inventory Server Property/Location

     Note

     Location is a custom property, which you need to associate with a server on the BMC Server Automation Application Server.

   • Server/Agent Major Version
   • Server/Agent Minor Version 
     
7. Add a built-in filter as follows:
   
   1. Open the Filters folder.

1. 1. To show the latest attributes of a server, drag the Show Latest Server Attributes filter to the right pane.

1. Drag the following query item to the right pane: Server/Agent State

1. Click the Run Report link.
2. Click the Run with All Data link.
   The report shows the health of agents installed on servers in different locations.  
3. To see the servers from a particular location together, select the Location column and click Sort in the toolbar.
   The report is sorted by the Location column.
4. If you want to see the agent version in x.y format, apply calculations (multiply the minor version by 0.1 and then add it to major version), as follows:

1. 1. Right-click the Agent Minor Version column and select Calculate.

1. 1. From Operation, select multiplication.

1. 1. In the Number field, type 0.1.

1. 1. Click Insert.
      A new column is inserted with the name, Agent Minor Version * 0.1.

1. 1. Select the Agent Major Version column and the newly inserted column.

1. 1. Right-click and select Calculate.

1. 1. In the New item name field, type Agent Version as the name of the new column. 

1. 1. Click Insert.
      The Agent Version column is inserted. This column shows the agent version in x.y format.

1. Delete the Agent Major Version, Agent Minor Version, and Agent Minor Version * 0.1 columns.

1. Save the report.
   The following figure shows a sample Inventory report created by using this procedure: 
   

Related topics

Sample-reports-demonstrating-Query-Studio-features
Creating-reports-with-Report-Studio