View the list of affected reports

You can view a list of all impacted reports identified by the ACL assessment for reports. Use this list to remediate affected reports and users.

Before you begin

Roles required: admin and security_admin.

Procedure

1. Navigate to All > Reports > ACL Assessment for Reports > Affected Reports List.
   The list report shows the affected reports.

   Column	Description
   Report	The report name with a hyperlink to its form.
   Table	The source table of the report.
   DBView Referenced ACL Table	When this column is populated, the report is affected because of an ACL on one of the tables that the database view is based on. Sometimes an affected report is based on a database view with an ACL. In this case, the name of the database view appears below the name of the table in the Table column.
   Dot Walk Fields	When this column is populated, the report is affected because of an ACL on an extended table. For more information, see Report on extended tables.
   Total executions	The number of times a user has viewed the report. This column is empty if the property run_scan_based_on_report_execution_only is false.
   Last execution	The timestamp of the most recent time execution of the report. This column is populated if the property run_scan_based_on_report_execution_only is true.
   is global	True / False. If true, the report owner has shared it with all users. If false, the report owner has shared it with specific users, groups, or roles.
   Shared to roles	Roles the report owner has shared it with (regardless of access control list). This field is empty if the report is global.
   Shared to users	Users the report owner has shared it with (regardless of access control list). This field is empty if the report is global.
   Shared to groups	Groups the report owner has shared it with (regardless of access control list). This field is empty if the report is global.
   Is blocked by read ACL	This column shows true if a read ACL blocks a user.
   Read ACL table	Shows the name of the table checked if the user is blocked by a read ACL.
   Is blocked without RVA or Read ACL	This column shows true if a report is blocked because the table the report is based on has neither a report_view ACL nor a read ACL.
   Blocked by table ACLs	If a table ACL (or column ACL that applies to all columns in a table) blocks a user, this column shows the name of the ACL.
   Blocked by table ACLs roles	The roles defined in the table ACL whose members can view reports based on the ACL. A user needs at least one of these roles to see the report.
   Table ACLs link	Click the link to view a list of the table ACLs that apply to the impacted report. The Role field in the list shows the required roles. A user must have one of the roles to view reports based on the table.
   Blocked by column ACLs	If a specific column ACL blocks a user, this column shows the name of the ACL.
   Blocked by column ACLs roles	The roles defined in the column ACL whose members can view reports based on the column. A user needs at least one of these roles to see the report.
   Column ACLs link	Click the link to view the column ACLs that apply to the impacted report. The Role field in the list shows the required roles. A user must have one of the roles to view reports based on the column.

2. Address the affected reports and users as described in Manage Report ACL assessments.