Skip to main content

SharePoint Reports

SharePoint reports are accessed through the Resource Audit interface. Explore the SharePoint resources by expanding the levels within the Resources pane and selecting the desired resource. The data within these reports is collected by the Access Analyzer SharePoint solution. See the SharePoint Solution topic in the Netwrix Access Analyzer Documentation for additional information.

SharePoint resource reports identify the following information in the targeted SharePoint on-premise farms and SharePoint Online instances:

  • What web applications, sites, lists, and libraries exist across the organization
  • What permissions users and groups have on sites, lists, and libraries
  • How it all translates into effective access
  • What users are doing on SharePoint sites, lists, and libraries
  • What potentially sensitive data exists across the targeted environment

SharePoint reports fall into the following categories:

  • Access Reports

    • Report on permissions, effective access, and exceptions
    • Data collected by the Access Analyzer SharePoint Access Auditing collection jobs
  • Activity Reports

    • Report on monitored activity

    • Data collected by the Access Analyzer SharePoint Activity Auditing collection jobs

    • Display information for a selected date range with local time stamps

    • Some of the reports also include trend graphs. Trend graphs provide a visual representation of the activity that occurred over the selected date range. See the Activity Report Results Pane Features topic for instructions on selecting a date range and filtering the trend graphs.

    • Activity information is represented in two ways:

      • Activity Statistics – Statistics reports show the count of operation events performed for the selected resource within the selected date range. These events are normalized into the operations of Reads, Writes, Deletes, and Manages.
      • Activity Details – Details reports show the specific operation events that occurred for the selected resource within the selected date range
  • Sensitive Data Content Reports

    • Report on files with potentially sensitive data
    • Data collected by the Access Analyzer SharePoint Sensitive Data Discovery Auditing collection jobs

The following reports are available at the SharePoint node and provide information for both SharePoint on-premise farms and SharePoint Online instances:

SharePoint Reports Quick Reference Guide

The following SharePoint reports are available for selections within the Resources pane.

SharePoint Node Reports

The following reports are available at the SharePoint node level:

ReportDescription
Exceptions ReportProvides a list of exceptions that were found across the targeted SharePoint on-premise farms and SharePoint Online instances. This report includes a Details table.
Sensitive Content Summary ReportProvides a count of files where criteria matches were found in the targeted SharePoint on-premise farms and SharePoint Online instances. This report includes a Details table.
Server Summary ReportProvides a top-level view of servers and instances that are representative of the targeted SharePoint on-premise farms and SharePoint Online instances.

SharePoint > Farm / Instance Levels Reports

The following reports are available at the on-premise farm and online instance level:

ReportDescription
Activity Details ReportProvides statistical activity event information by user on the selected farm during the specified date range. This report includes a line graph for Active Users Trend.
Anonymous Access Links ReportDisplays files that have access links generated to be shared with people outside the organization (guest/anonymous users).
Exceptions ReportProvides a list of exceptions that were found within the selected farm/instance. This report includes a Details table.
External Sharing ReportDisplays resources that are shared with external users, such as users who are invited to sign in using their gmail accounts.
Scan Summary ReportProvides a summary view of all site collections on the selected farm/instance.
Sensitive Content Details ReportProvides details of files where criteria matches were found on the site collection. This report includes a Matches table.
Sensitive Content Summary ReportProvides a count of files where criteria matches were found on the site collection. This report includes a Details table.

SharePoint > Farm > Web Application & Web Application URL Levels Reports

The following reports are available at the web application and web application URL levels:

ReportDescription
Effective Policy ReportProvides a list of users and groups who are effectively granted or denied access to the SharePoint on-premise farm web application through a particular web application policy with the rights being either granted or denied.
Policy ReportProvides a list of web application policies assigned for the selected SharePoint on-premise farm web application.

SharePoint > Instance > Teams Node Reports

The following report is available at the Teams node level:

ReportDescription
Teams Scan SummaryProvides an overview of scanned Teams servers.

SharePoint > Farm / Instance > Web Application > Site Collections / Sites / Lists / Libraries / Folders Levels Reports

The following reports are available at the site collection, site, list, library, and folder levels:

ReportDescription
Activity Details ReportProvides statistical activity event information by user on the selected server during the specified date range. This report includes a line graph for Active Users Trend.
Effective Access ReportProvides insight into who has what level of access to this resource through a calculation that encompasses web application policies, administrative access, resource permissions, and group membership. It contains a list of all trustees with access to the selected resource and specifies the effective access level. This report includes a Permission Source table.
Exceptions ReportProvides a list of all trustees with access that are causing exceptions on the selected resource. This report includes a Permissions Source table.
Permissions ReportProvides a list of trustees with permissions for the selected resource. This report includes a table with trustee access levels Compared to Parent.
Sensitive Content ReportProvides a list of files and a hit count per file where criteria matches were found on the selected resource. This report includes a Matches table.
Site Collection Roles ReportProvides a list of all roles or permission levels for the selected site collection, including custom defined roles and role descriptions. It also displays a calculation of the actual rights that each role grants within the targeted SharePoint on-premise farm or SharePoint Online instance. NOTE: This report is only available at the site collection level.

SharePoint > Farm / Instance > Exceptions Node Reports

The following report is available at the Exceptions node level:

ReportDescription
Exceptions ReportProvides a list of exceptions found on the farm/instance. This report includes a Details table.

SharePoint > Farm / Instance > Exceptions > Exception Type Level Reports

The following report is available at the exceptions type level:

ReportDescription
Exceptions by Type ReportProvides details on the selected exception type. An exception is defined as a problem or risk to data governance security. This report includes a Permission Source table.

Server Summary Report

The Server Summary report at the SharePoint node provides a top-level view of servers and instances that are representative of the targeted SharePoint on-premise farms and SharePoint Online instances.

Server Summary report

This report is comprised of the following columns:

  • Server Name – Single server name representing the entire SharePoint on-premise farm or SharePoint Online instance
  • Version – SharePoint version
  • Site Collections – Count of site collections on the farm/instance
  • Sites – Count of sites on the farm/instance
  • Exceptions – Count of exceptions on the farm/instance
  • Last Scanned – Date and timestamp of the last Access Analyzer scan

Exceptions Report

The Exceptions report at the SharePoint node provides a list of exceptions that were found across the targeted SharePoint on-premise farms and SharePoint Online instances. This report includes a Details table.

Exceptions report at the SharePoint node

An exception is defined as a problem or risk to data governance security. Exceptions include open access and permissions granted to stale or disabled users. This table will be blank if no exceptions were found within the targeted farm/instance. This report is comprised of the following columns:

  • Server Name – Single server name representing the entire SharePoint on-premise farm or SharePoint Online instance
  • Name – Type of exception found
  • Description – Description of the exception type
  • Count – Number of this type of exception found on the farm/instance

There is one table at the bottom displaying Details for the selected exception:

  • Trustee Name – Owner of the trustee account
  • Path – Location of the resource where the exception exists

Exceptions Node Report

The following report is available at the Exceptions node:

The Exceptions node displays when exceptions have been identified on the selected farm/instance. When it is present, it can be expanded to view the exception type level reports. The following nodes may show under the Exceptions node for a SharePoint resource when that exception type has been identified:

  • Disabled Users – Site collections, sites, libraries, lists, or folders where disabled users have been granted access
  • Open resources – Site collections, sites, libraries, lists, or folders that are openly accessible
  • Stale Users – Site collections, sites, libraries, lists, or folders where stale users have been granted access
  • Unresolved SID – Site collections, sites, libraries, lists, or folders where the trustee is an unknown SID, not matched to a known trustee account within Active Directory for on-premise farms or Entra ID for online instances, have been granted access

The Exceptions report for each exception type level displays filtered exception information. See the Exceptions by Type Report topic for the report details.

Exceptions Report

The Exceptions report at the Exceptions node provides a list of exceptions found on the farm/instance. This report includes a Details table.

Exceptions report at the Exceptions node

An exception is defined as a problem or risk to data governance security. Exceptions include open access and permissions granted to stale or disabled users. This report is comprised of the following columns:

  • Server Name – Single server name representing the entire SharePoint on-premise farm or SharePoint Online instance
  • Name – Type of exception found
  • Description – Description of the exception type
  • Count – Number of this type of exception found on the farm/instance

There is one table at the bottom displaying Details for the selected exception:

  • Trustee Name – Owner of the trustee account
  • Path – Location of the resource where the exception exists

Exceptions by Type Report

The Exceptions report at the exception type level provides details on the selected exception type. An exception is defined as a problem or risk to data governance security. This report includes a Permission Source table.

Exceptions report at the exception type level

This report is comprised of the following columns:

  • Trustee Name – Owner of the trustee account
  • Path – Location of the resource where the exception exists

If the selected trustee in the top section of the report is a group, the Group Membership pane displays the group membership, including nested groups.

There is one table at the bottom displaying Permission Source for the select trustee. It contains all of the ways the selected trustee has been granted rights to the selected resource.

Permission Source table

The number of rows for this table indicates the number of ways this trustee has been granted access. This table is comprised of the following columns:

  • Source Path – Location for which the trustee was granted rights to the selected resource, which can be represented two ways:

    • Directly Applied – Rights granted directly to the selected trustee
    • Access through another trustee, path starts with trustee assigned the direct rights and shows all nested groups leading to the selected trustee
  • Source Type – Source of the permission (for example, Site Permission, Web Application Policy, Site Collection Administrator, and so on)

  • Source Name – Name of the site collection, site, library, list, or folder where the permission is assigned

The following rights are a normalized representation of the SharePoint permission levels (SharePoint Roles) granted to the trustee:

  • List – Right to view list of SharePoint resources
  • Read – Right to view/read SharePoint resources
  • Write – Right to add or modify SharePoint resources
  • Delete – Right to delete SharePoint resources
  • Manage – Equivalent to full control over SharePoint resources

The following columns display the combined direct and inherited rights:

  • Allow Mask – Bitmask corresponding to Windows ACE permission bits for combined direct and inherited allow rights
  • Deny Mask – Bitmask corresponding to Windows ACE permission bits for combined direct inherited deny rights

On-Premise Farm & Online Instance Levels Reports

The following reports are available at the on-premise farm and online instance levels and provide information for both on-premise farms and online instances, unless otherwise specified:

Activity Details Report

The Activity Details report at the on-premise farm and online instance levels provides statistical activity event information by user on the selected farm during the specified date range. This report includes a line graph for Active Users Trend.

Activity Details report at the on-premise farm and online instance levels

This report is comprised of the following columns:

  • Access Time – Date and timestamp for when the operation occurred
  • Trustee Name – Owner of the trustee account
  • Trustee Account – Active Directory account associated with the trustee
  • Department – Department to which the trustee account belongs
  • Title – Trustee’s title as read from Active Directory
  • Mail – Trustee’s email account as read from Active Directory
  • EmployeeId – Corporate ID for the employee as read from Active Directory
  • Description – Description of the trustee object as read from Active Directory
  • DistinguishedName – Distinguished name for the trustee account
  • ObjectSid – Security ID of the object
  • Disabled – True or False if trustee account is disabled
  • Deleted – True or False if trustee account is deleted
  • Resource – Resource type being accessed
  • Operation – Name of operation logged
  • Access – Whether the trustee was granted access to execute the operation: Allowed or Denied
  • Path – Original location where the operation occurred
  • Target Path – New location if changed by the operation. Blank if the operation does not result in a new path.
  • Process Name – Name of the process which performed the operation

The table data grid functions the same way as other table grids. See the Data Grid Features topic for additional information.

There is one line graph at the bottom displaying Active Users Trend for the selected resource.

Active Users Trend graph

The Active Users Trend line graph provides a visual representation of the number of active users over the selected date range. It indicates how many users are performing activity per day.

See the Activity Report Results Pane Features topic for instructions on filtering the trend graph.

Anonymous Access Links Report

The Anonymous Access Links report at the online instance level displays files that have access links generated to be shared with people outside the organization (guest/anonymous users).

Anonymous Access Links report at the online instance level

This report is comprised of the following columns:

  • Site Collection – Site collection where the shared file resides
  • File Name – Name of the shared file
  • Access – Level of access granted to the external users
  • URL – URL path to the file

Exceptions Report

The Exceptions report at the on-premise farm and online instance levels provides a list of exceptions that were found within the selected farm/instance. This report includes a Details table.

Exceptions report at the on-premise farm and online instance levels

An exception is defined as a problem or risk to data governance security. Exceptions include open access and permissions granted to stale or disabled users. This report will be blank if no exceptions were found on the selected farm/instance. It is comprised of the following columns:

  • Server Name – Single server name representing the entire SharePoint on-premise farm or SharePoint Online instance
  • Name – Type of exception found
  • Description – Description of the exception type
  • Count – Number of this type of exception found on the server

There is one table at the bottom displaying Details for the selected exception:

  • Trustee Name – Owner of the trustee account
  • Path – Location of the resource where the exception exists

External Sharing Report

The External Sharing report at the online instance level displays resources that are shared with external users, such as users who are invited to sign in using their gmail accounts.

External Sharing report at the online instance level

This report is comprised of the following columns:

  • Resource Name – Name of the shared resource
  • Resource Type – Type of SharePoint resource
  • Email – Email account of the external user
  • Access – Level of access granted to the external users
  • URL – URL path to the resource

Scan Summary Report

The Scan Summary report at the on-premise farm and online instance levels provides a summary view of all site collections on the selected farm/instance.

Scan Summary report at the on-premise farm and online instance levels

This report is comprised of the following columns:

  • Web Application

    • On-premises farm – Name of the web application to which the site collection belongs
    • Online instance – Reflects the main nodes in the resource tree. The value is either Personal, Public, or SharePoint.
  • Site Collection

    • On-premises farm – Display name of the site collection

    • Online instance – Display types of site collections

      • Personal – Resources found under the OneDrive for Business node
      • Public – Resources found under the Public node
      • SharePoint – Resources directly under the online instance level
  • Url – URL path to the site collection

  • Resources – Count of resources within the site collection

  • Exceptions – Count of exceptions within the site collection

Web Application & Web Application URL Levels Reports

The following reports are available at the web application and web application URL levels and provide information for SharePoint on-premise farms:

Effective Policy Report

The Effective Policy report at the web application and web application URL levels provides a list of users and groups who are effectively granted or denied access to the SharePoint on-premise farm web application through a particular web application policy with the rights being either granted or denied.

Effective Policy report at the web application and web application URL levels

This report is comprised of the following columns:

  • Zone – Zone to which the policy is applied (for example, internet, intranet, default, and so on)
  • Url – URL path to the site collection
  • Trustee Name – Owner of the trustee account
  • Trustee Account – Active Directory account associated with the trustee
  • Department – Department to which the trustee account belongs
  • Title – Trustee’s title as read from Active Directory
  • Mail – Trustee’s email account as read from Active Directory
  • EmployeeId – Corporate ID for the employee as read from Active Directory
  • Description – Description of the trustee object as read from Active Directory
  • DistinguishedName – Distinguished name for the trustee account
  • ObjectSid – Security ID of the object
  • Disabled – True or False if trustee account is disabled
  • Stale – True or False if trustee account is stale (according to the length of inactive time used by the Access Analyzer data collection and analysis configuration to identify stale accounts)
  • Deleted – True or False if trustee account is deleted

The following rights are a normalized representation of the SharePoint permission levels (SharePoint Roles) granted to the trustee:

  • Read – Right to view/read SharePoint resources
  • Write – Right to add or modify SharePoint resources
  • Delete – Right to delete SharePoint resources
  • Manage – Equivalent to full control over SharePoint resources

If the selected trustee in the top section of the report is a group, the Group Membership pane displays the group membership, including nested groups.

To view the granular rights granted through SharePoint permission levels (SharePoint Roles), see the Roles column in the Permissions Report. For additional detail on what permissions each SharePoint Role grants, see the Permission Mask column in the Site Collection Roles Report.

Policy Report

The Policy report at the web application and web application URL levels provides a list of web application policies assigned for the selected SharePoint on-premise farm web application.

Policy report at the web application and web application URL levels

This report is comprised of the following columns:

  • Zone – Zone to which the policy is applied (for example, internet, intranet, default, and so on)
  • Url – URL path to the site collection
  • Trustee Name – Owner of the trustee account
  • Trustee Account – Active Directory account associated with the trustee
  • Department – Department to which the trustee account belongs
  • Title – Trustee’s title as read from Active Directory
  • Mail – Trustee’s email account as read from Active Directory
  • EmployeeId – Corporate ID for the employee as read from Active Directory
  • Description – Description of the trustee object as read from Active Directory
  • DistinguishedName – Distinguished name for the trustee account
  • ObjectSid – Security ID of the object
  • Disabled – True or False if trustee account is disabled
  • Stale – True or False if trustee account is stale (according to the length of inactive time used by the Access Analyzer data collection and analysis configuration to identify stale accounts)
  • Deleted – True or False if trustee account is deleted

The following rights are a normalized representation of web application policy permission granted to the trustee:

  • Read – Right to view/read resources
  • Write – Right to add or modify SharePoint resources
  • Delete – Right to delete SharePoint resources
  • Manage – Equivalent to full control over SharePoint resources

If the selected trustee in the top section of the report is a group, the Group Membership pane displays the group membership, including nested groups.

Site Collection, Site, List, Library, & Folder Level Reports

The following reports are available at the site collection, site, list, library, and folder levels and provide information for both SharePoint on-premise farms and SharePoint Online instances:

Activity Details Report

The Activity Details report at the site collection, site, list, library, and folder levels provides statistical activity event information by user on the selected server during the specified date range. This report includes a line graph for Active Users Trend.

The Include subfolders option is active by default until removed. See the Results Pane topic for information on changing this option.

Activity Details report at the site collection, site, list, library, and folder levels

This report is comprised of the following columns:

  • Access Time – Date and timestamp for when the operation occurred
  • Trustee Name – Owner of the trustee account
  • Trustee Account – Active Directory account associated with the trustee
  • Department – Department to which the trustee account belongs
  • Title – Trustee’s title as read from Active Directory
  • Mail – Trustee’s email account as read from Active Directory
  • EmployeeId – Corporate ID for the employee as read from Active Directory
  • Description – Description of the trustee object as read from Active Directory
  • DistinguishedName – Distinguished name for the trustee account
  • ObjectSid – Security ID of the object
  • Disabled – True or False if trustee account is disabled
  • Deleted – True or False if trustee account is deleted
  • Resource – Resource type being accessed
  • Operation – Name of operation logged
  • Access – Whether the trustee was granted access to execute the operation: Allowed or Denied
  • Path – Original location where the operation occurred
  • Target Path – New location if changed by the operation. Blank if the operation does not result in a new path.
  • Process Name – Name of the process which performed the operation

The table data grid functions the same way as other table grids. See the Data Grid Features topic for additional information.

There is one line graph at the bottom displaying the Active Users Trend for the selected event.

Active Users Trend graph

The line graph provides a visual representation of the number of active users over the selected date range. It indicates how many users are performing activity per day.

See the Activity Report Results Pane Features topic for instructions on filtering the trend graph.

Effective Access Report

The Effective Access report at the site collection, site, list, library, and folder levels provides insight into who has what level of access to this resource through a calculation that encompasses web application policies, administrative access, resource permissions, and group membership. It contains a list of all trustees with access to the selected resource and specifies the effective access level. This report includes a Permission Source table.

Effective Access report at the site collection, site, list, library, and folder levels

This report is comprised of the following columns:

  • Trustee Name – Owner of the trustee account

  • Trustee Account:

    • On-premises farm – Active Directory account associated with the trustee
    • Online instance – Entra ID account associated with the trustee
  • Department – Department to which the trustee account belongs

  • Title – Trustee’s title as read from Active Directory for on-premise farms or Entra ID for online instances

  • Mail – Trustee’s email account as read from Active Directory for on-premise farms or Entra ID for online instances

  • EmployeeId – Corporate ID for the employee as read from Active Directory for on-premise farms or Entra ID for online instances

  • Description – Description of the trustee object as read from Active Directory for on-premise farms or Entra ID for online instances

  • DistinguishedName – Distinguished name for the trustee account

  • ObjectSid – Security ID of the object

  • Disabled – True or False if trustee account is disabled

  • Deleted – True or False if trustee account is deleted

  • Stale – True or False if trustee account is stale (according to the length of inactive time used by the Access Analyzer data collection and analysis configuration to identify stale accounts)

  • Direct – True or False if the permission is directly assigned

  • Changed – True or False if the trustee has changes modeled that would impact access to the selected resource

The following rights are a normalized representation of the SharePoint permission levels (SharePoint Roles) granted to the trustee:

  • Read – Right to view/read SharePoint resources
  • Write – Right to add or modify SharePoint resources
  • Delete – Right to delete SharePoint resources
  • Manage – Equivalent to full control over SharePoint resources

If the selected trustee in the top section of the report is a group, the Group Membership pane displays the group membership, including nested groups.

There is one table at the bottom displaying Permission Source for the select trustee. It contains all of the ways the selected trustee has been granted rights to the selected resource. To view the granular rights granted through SharePoint permission levels (SharePoint Roles), see the Role Name column.

Permission Source table

The number of rows for this table indicates the number of ways this trustee has been granted access. This table is comprised of the following columns:

  • Source Path – Location for which the trustee was granted rights to the selected resource, which can be represented two ways:

    • Directly Applied – Rights granted directly to the selected trustee
    • Access through another trustee, path starts with trustee assigned the direct rights and shows all nested groups leading to the selected trustee
  • Source Type – Source of the permission (for example, Site Permission, Web Application Policy, Site Collection Administrator, and so on)

  • Source Name – Name of the resource where the permission is assigned

The following rights are a normalized representation of the SharePoint permission levels (SharePoint Roles) granted to the trustee:

  • List – Right to view list of SharePoint resources
  • Read – Right to view/read SharePoint resources
  • Write – Right to add or modify SharePoint resources
  • Delete – Right to delete SharePoint resources
  • Manage – Equivalent to full control over SharePoint resources

The following columns display the combined direct and inherited rights:

  • Allow Mask – Bitmask corresponding to Windows ACE permission bits for combined direct and inherited allow rights
  • Deny Mask – Bitmask corresponding to Windows ACE permission bits for combined direct inherited deny rights

This table provides the insight necessary to make modifications to a trustee's access. For example, a trustee has three sources of access to the selected resource. One source is directly applied, and two sources are through permissions granted to another trustee. In order for this trustee’s access to the selected resource to be changed, each of these source paths must be taken into consideration.

Exceptions Report

The Exceptions report at the site collection, site, list, library, and folder levels provides a list of all trustees with access that are causing exceptions on the selected resource. This report includes a Permission Source table.

Exceptions report at the site collection, site, list, library, and folder levels

An exception is defined as a problem or risk to data governance security. Exceptions include open access and permissions granted to stale or disabled users. This table is blank unless an Exception icon is attached to the resource in the Resources pane, indicating exceptions were found. See the Resources Pane topic for additional information.

This report is comprised of the following columns:

  • Name – Type of exception found
  • Trustee Name – Owner of the trustee account
  • Path – Location of the resource where the exception exists

There is one table at the bottom displaying Permission Source for the select trustee. It contains all of the ways the selected trustee has been granted rights to the selected resource.

Permission Source table

The number of rows for this table indicates the number of ways this trustee has been granted access. This table is comprised of the following columns:

  • Source Path – Location for which the trustee was granted rights to the selected resource, which can be represented two ways:

    • Directly Applied – Rights granted directly to the selected trustee
    • Access through another trustee, path starts with trustee assigned the direct rights and shows all nested groups leading to the selected trustee
  • Source Type – Source of the permission (for example, Site Permission, Web Application Policy, Site Collection Administrator, and so on)

  • Source Name – Name of the resource where the permission is assigned

The following rights are a normalized representation of the SharePoint permission levels (SharePoint Roles) granted to the trustee:

  • List – Right to view list of SharePoint resources
  • Read – Right to view/read SharePoint resources
  • Write – Right to add or modify SharePoint resources
  • Delete – Right to delete SharePoint resources
  • Manage – Equivalent to full control over SharePoint resources

The following columns display the combined direct and inherited rights:

  • Allow Mask – Bitmask corresponding to Windows ACE permission bits for combined direct and inherited allow rights
  • Deny Mask – Bitmask corresponding to Windows ACE permission bits for combined direct inherited deny rights

Permissions Report

The Permissions report at the site collection, site, list, library, and folder levels provides a list of trustees with permissions for the selected resource. This report includes a table with trustee access levels Compared to Parent.

Permissions report at the site collection, site, list, library, and folder levels

This report is comprised of the following columns:

  • Trustee Name – Owner of the trustee account

  • Trustee Account:

    • On-premises farm – Active Directory account associated with the trustee
    • Online instance – Entra ID account associated with the trustee
  • Department – Department to which the trustee account belongs

  • Title – Trustee’s title as read from Active Directory for on-premise farms or Entra ID for online instances

  • Mail – Trustee’s email account as read from Active Directory for on-premise farms or Entra ID for online instances

  • EmployeeId – Corporate ID for the employee as read from Active Directory for on-premise farms or Entra ID for online instances

  • Description – Description of the trustee object as read from Active Directory for on-premise farms or Entra ID for online instances

  • DistinguishedName – Distinguished name for the trustee account

  • ObjectSid – Security ID of the object

  • Disabled – True or False if trustee account is disabled

  • Deleted – True or False if trustee account is deleted

  • Stale – True or False if trustee account is stale (according to the length of inactive time used by the Access Analyzer data collection and analysis configuration to identify stale accounts)

  • Type – Direct or Inherited type of permission

  • Roles – Role name for the SharePoint permission level. For additional detail on what permissions each Role grants, see the Permission Mask column in the Site Collection Roles Report.

The following rights are a normalized representation of the SharePoint permission levels (SharePoint Roles) granted to the trustee:

  • Read – Right to view/read SharePoint resources
  • Write – Right to add or modify SharePoint resources
  • Delete – Right to delete SharePoint resources
  • Manage – Equivalent to full control over SharePoint resources

If the selected trustee in the top section of the report is a group, the Group Membership pane displays the group membership, including nested groups.

There is one table at the bottom displaying Compared to Parent permissions for the select trustee. It contains information on explicit permissions granted for the selected resource.

Compared to Parent table

This table is blank unless an Explicit Permissions icon is attached to the resource in the Resources pane. See the Resources Pane topic for additional information. This table is comprised of the same columns as the primary report, with the exception that it does not have the Roles column.

Site Collection Roles Report

The Site Collections Roles report at the site collection level provides a list of all roles or permission levels for the selected site collection, including custom defined roles and role descriptions. It also displays a calculation of the actual rights that each role grants within the targeted SharePoint on-premise farm or SharePoint Online instance.

NOTE: This report is only available at the site collection level.

Site Collections Roles report

This report is comprised of the following columns:

  • Role – Role name for the SharePoint permission level
  • Description – Description of the SharePoint role, this is an open text entry within SharePoint and may not accurately represent the granular rights granted through the SharePoint permission level
  • Permission Mask – Representation of the granular rights mapped to the permission level in SharePoint

The following rights are a normalized representation of the SharePoint permission levels (SharePoint Roles) granted to the trustee:

  • Read – Right to view/read SharePoint resources
  • Write – Right to add or modify SharePoint resources
  • Delete – Right to delete SharePoint resources
  • Manage – Equivalent to full control over SharePoint resources