Sample Inventory report with groups and calculations

This example demonstrates how to create an Inventory report that shows the last restart time of a server and the duration for which a server has been running since the last restart.

To create an Inventory report with groups and calculations

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/Machine Summary/Last Boot Time
7. Group the report by the OS Name and OS Version columns.
8. Apply the following calculation to the Last Boot Time column: Current time - Last Boot Time.
9. Rename the Current time - Last Boot Time column as the Server uptime column.
10. Format the Server Uptime column as follows:
    1. Right-click the column and select Format Data.
    2. From the Category list, select Interval.
    3. Select the following format: 1 23:45:12
    4. Click OK.
11. Sort the Server uptime column in descending order.
12. Click the Run Report link.
13. Click the Run with All Data link.
14. On the Prompt page, select the required option. (For information about options, see Running an Inventory report.)
15. 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 Query Studio