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.

Creating a report with filters, groups, and conditional styles

The following example demonstrates how to retrieve the latest job run summary for the last 90 days.

DomainReport nameFeatures used
AuditAudit latest job run summary for the last 90 days
  • Add filters
  • Group data
  • Apply conditional style

You add a filter to retrieve the latest job run summary for the last 90 days. You can apply conditional styles to apply different background colors on the Errors On Target and Total Differences columns depending on the values of these columns.

To create a report with filters, groups, and conditional styles

  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 Audit folder and drag the following query items to the right pane:
    • Audit Job Run Date/Week of Year
    • Audit Job Run Date/Calender Date
    • Audit Job/Job Name
    • Audit Job/Job Run Start Time
    • Audit Target Component/Target Server Name
    • Audit Summary/Object Type
    • Audit Summary/Errors On Target
    • Audit Summary/Total Differences
    • Audit Summary/Extra On Target
    • Audit Summary/Missing On Target
    • Audit Summary/Changed On Target
  7. Open the Audit/Audit Filters folder and drag the Audit Job Latest Run filter to the right pane to display only the latest job runs.
  8. Select the Job Run Start Time column and click Filter on the toolbar.
  9. In the Filters dialog box, from the Operation list, select Last number of days.
  10. In the Number of days before today field, type 90, and click OK.
  11. When you are prompted to combine the filter conditions, click OK.
  12. Apply the conditional style to the Errors On Target column as follows. The query item is highlighted in a different color if its value is greater than 0.
    1. Right-click the column and select Define Conditional Styles to open the Define conditional styles dialog box.
    2. In the New value field, type 0.
    3. Click Insert.
    4. In Style, for a value greater than 0, click Edit Style to open the Change font styles dialog box.
    5. Select a background color, and click OK.
    6. Click OK.
  13. Apply the conditional style to the Total Differencescolumn as follows. The query item is highlighted in a different color if its value is greater than 0 and in a different color for a value less than or equal to 0.
    1. Right-click the column and select Define Conditional Styles to open the Define conditional styles dialog box.
    2. In the New value field, type 0.
    3. Click Insert.
    4. In Style, for a value greater than 0, click Edit Style to open the Change font styles dialog box.
    5. Select a background color and click OK.
    6. In Style, for a value less than or equal to 0, click Edit Style to open the Change font styles dialog box.
    7. Select a background color and click OK.
    8. Click OK.
  14. Select the Week of Year, Calender Date, Job Name, Job Run Start Time, and Target Server Name columns and click Group on the toolbar to group the data by these columns.
  15. Click the Run Report link.
  16. Click the Run with All Data link.
  17. 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

Was this page helpful? Yes No Submitting... Thank you

Comments