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 ad hoc reports and views in a multi-tenant environment

    MultiExcerpt named 'Product_Name' was not found
The multiexcerpt named 'Product_Name' was not found. Please check the page name and MultiExcerpt name used in the MultiExcerpt Include macro. supports the CUSTOMER server property in all domains. You can use this property to create ad hoc reports in a multitenant environment. For example, you can create individual reports that show weekly compliance summaries for tenants. Additionally, you can create separate report views for each tenant that contain the weekly compliance summary report for that specific tenant.

This topic describes how to create a sample ad hoc report and how to create report views for specific tenants.

Before you begin

  1. Populate the customer property in BMC Server Automation.
  2. Run ETL to transfer information for the CUSTOMER property.

To create the weekly compliance summary report

  1. Log on to the
      MultiExcerpt named 'Product_Name' was not found
    The multiexcerpt named 'Product_Name' was not found. Please check the page name and MultiExcerpt name used in the MultiExcerpt Include macro. portal.
  2. Launch Query Studio.
  3. Select a package from the list of available packages (for example, BladeLogic).
  4. In the report creation window, click the Run Report link.
  5. Click the Preview with No Data link.
  6. Click the Insert Data link.
  7. Expand the Compliance folder.
  8. From the Compliance Server Property query subject, drag the CUSTOMER property to the right pane.
  9. Select the CUSTOMER column and click Filter on the toolbar to view the report for a specific tenant, such as Tenant2.
  10. In the Filters dialog box, select the Prompt every time the report runs check box.
    Each time you open or run the report, you can choose or type in the filter values. If you do not specify any filter values, all relevant data is returned.
  11. From the Condition list, select Tenant2 and click OK.
    The report creation window shows results only for Tenant2.
  12. Drag the following query items to the right pane:
    • Compliance Job Run Date/Year
    • Compliance Job Run Date/Week of Year
    • Compliance Template(Policy)/Template(Policy) Name
    • Compliance Server/Server Name
    • Compliance Server Result/Rules Checked
    • Compliance Server Result/Rules Compliant
    • Compliance Server Result/Rules Non Compliant
    • Compliance Server Result/% Compliance
      The following figure shows a sample report, which is created by using the preceding steps:
  13. Click Save.
  14. Enter the name and description for the report.
  15. Specify the location where you want to save the report.
  16. Click OK.

To create a view of the report for a specific tenant

  1. Navigate to the folder where you saved the report.
  2. Click the Create a report view of this report icon next to the report.
  3. Enter a name for the report view, such as Weekly Compliance Summary - Tenant1.
  4. Enter a description for the report view.
  5. Click Finish.
  6. Repeat step 1 through step 5 to create another report view, such as Weekly Compliance Summary - Tenant2.

Where to go from here

Scheduling ad hoc reports and views

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

Comments