Creating a report with filters and calculations

The following example demonstrates how to retrieve the jobs and job runs that took more than one hour to run in the last 365 days.

You add the Division function so that the time taken to execute a job or job run is displayed in hours, not in seconds.

To create a report with filters 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 Job Activity folder and drag the following query items to the right pane:
   • Job/Job Name
   • Job Runs/Job Run Start Time
   • Job Runs/Time To Execute (Sec)
   • Job Activity Calculations/# Servers Attempted
7. Select the Job Run Start Time column and click Filter on the toolbar.
8. From the Operation list, select Last number of days.
9. In the Number of days before today field, type 365, and click OK.
10. Select the Time To Execute (Sec) column and click Calculate on the toolbar.
11. From the Operation type list, select Arithmetic.
12. From the Operation list, select / (division).
13. Verify that in the Order list, Time To Execute (Sec) / <Number> is selected.
14. In the Number field, type 3600.
15. In the New item name field, enter Time To Execute (Hr) as the new column name.
16. Click Insert.
    A new column, Time To Execute (Hr), is added.
17. Select the Time To Execute (Hr) column and click Filter on the toolbar.
18. In the Filter dialog box, in the From field, type 1, and click OK.
19. In the Combine filters dialog box, click OK.
20. Select the Time To Execute (Sec) column, and click Delete on the toolbar.
21. Click the Run Report link.
22. Click the Run with All Data link.
23. 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