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 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.

Report name

Features used

Server uptime report

  • Group data
  • Add calculations

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:
    ServerUptime.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*