Sample Compliance report with filters, groups, sections, calculations, and summarization

This example demonstrates how to create a Compliance report that shows the top five rules that failed across templates.

To create a Compliance report with filters, groups, sections, calculations, and summarization

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 Compliance folder and drag the following query items to the right pane:
   • Compliance Template(Policy)/Template(Policy) Name
   • Compliance Rule/Rule Name
   • Compliance Server/Server Name
   • Compliance Job/Job Run Start Time
   • Compliance Rule Result/Rules Non Compliant
   • Compliance Rule Result/Rules Indeterminate
7. Apply the Sum function on the Rules Non Compliant and Rules Indeterminate columns as follows:
   1. Select the columns and click Calculate on the toolbar.
   2. From the Operation type list, select Arithmetic.
   3. From the Operation list, select + (sum).
   4. Click Insert.
       A new column, Rules Non Compliant + Rules Indeterminate, is added.
8. Apply a filter on the Rules Non Compliant + Rules Indeterminate column as follows:
   1. Select the column and click Filter on the toolbar.
   2. In the From and To fields, type 1.
   3. Click OK.
9. Apply the Count function on the Server Name column, as follows:
   1. Right-click the column and select Summarize.
   2. In the Summarize dialog box, click Advanced.
   3. From the Summary for cells list, select Count.
   4. From the Summary for footers list, select None.
   5. Click OK.
10. Repeat step 9 for the Job Run Start Time column.
11. Apply the Count function on the Rules Non Compliant + Rules Indeterminate column, as follows:
    1. Right-click the column and select Summarize.
    2. In Cell values, verify that the Summarize first, then apply the calculation option is selected.
    3. In Footers, select the No summarization in the footers option.
    4. Click OK.
12. Sort the Rules Non Compliant + Rules Indeterminate column in descending order.
13. Click the Change Layout link.
14. Click the Set Web Page Size link.
15. In the Set web page size dialog box, from Number of rows, select 5.
16. Select the Show row numbers check box.
17. Click OK.
18. Delete the following columns without deleting the associated filters:
    • Job Run Start Time
    • Rules Non Compliant
    • Rules Indeterminate
    • Rules Non Compliant + Rules Indeterminate
19. Click the Run Report link.
20. Click the Run with All Data link.
21. Save the report.
     The following figure shows a sample Compliance report created by using this procedure:
    

Related topics

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