Using Report Filters to Limit the Output Data of a Report

Symptoms

In large Active Directory environments, the following reports can take too long to render because they generate a huge volume of output:

  • Authorization Report
  • Classic Zone – User Privileged Command Rights Report
  • Classic Zone – User Role Assignment Report
  • Hierarchical Zone - Computer Role Effective Assignments Report (UNIX)
  • Hierarchical Zone - Computer Role Effective Assignments Report (Windows)
  • Hierarchical Zone - Effective Audit Level Report
  • Hierarchical Zone - Effective Rights Report
  • Hierarchical Zone - Effective Role Report
  • Hierarchical Zone - Users Report
  • Hierarchical Zone - Zone Effective Assignments Report (UNIX)
  • Hierarchical Zone - Zone Effective Assignments Report (Windows)
  • All PCI reports
  • All SOX reports

Resolution

You can use report filters to limit the report to only list data for specific zone types and zones in a specific domain. This can reduce the amount of data output from the report and the report will take less time to render.

If you are opening the PCI and SOX reports, you can use the Zone Type filter to limit the reports to only list data for Classic zones or Hierarchical zones.

For all reports, you can use the Zone Domain filter to limit the reports to only list data for zones in a specific domain. By default, the Zone Domain filter of all the reports is set to the first zone domain.

By default, reports are set to run automatically when you open the report. If you prefer to set the reports to not run automatically upon opening, do the following. You must have manage report permission in order to configure the report.

To configure a report to not run automatically when you open the report:

  1. In the list of reports in the web browser, locate the desired report.
  2. Move your mouse pointer over the report to open the report context menu.
  3. From the context menu, select Manage.

  4. Select the Parameters page.

    Notice that ‘Has Default’ is selected for all parameters.

  5. Deselect the ‘Has Default’ setting for any one parameter.
  6. Click Apply to save the changes.

  7. Open the report.

    The report does not run automatically. You can specify the filter values and click “View Report” button to run the report.