Solution Report PermissionsReport
Solution Code: PermissionsReport
This report will provide the below information:
| Colum Title | Description |
|---|---|
| LocationType | Identify if the location is a Site, a List or an Item. |
| LocationName | Name of the Site, List or Item. |
| LocationUrl | Full URL or Server relative path of the location. |
| AccessType | Defines if the users have "Direct access" or through a "SharePoint Group". |
| AccountType | Defines if the account is a User or a Security Group. |
| Users | List of users with access. |
| PermissionsLevels | Permission level that the users have. |
| Remarks | Any additional information for extended clarification or errors. |
Run the solution with and account with at least SharePoint Admin role and Azure AD role.
| Parameter | Type | Definition |
|---|---|---|
| Site user list only | Required Choice |
The Solution will bring a list of all users in All People page of the Site. It's an overview of all users and groups that are registered on the site, independently of the permissions level, the location where they have access, or even if they don't have access anymore to the site. |
| Detailed report | Required Choice |
Report will include the permissions for the users on each of the locations selected below. |
| Site Collection Admin | Optional | List of users and groups that are Site Collection Admins |
| Site Permissions | Optional | List of users and groups that have access to the Site and their permissions levels. |
| Unique permissions | Optional | List of users, groups and shared links that have access to some part of the Site, due the list/library/folder/file/item having unique permissions. |
- Collects the required Sites.
- Add account as Site Collection Admin.
- Iterates through each site collecting the permissions per location as defined on the parameters permissions filter.
- Connects to Azure AD to collect users inside Security groups.
- Records the information for each action in a CSV file.
The system groups Everyone and Everyone except external users are added automatically in every SharePoint Site and OneDrive at the creation during its creation, even though they don't have any permissions. Therefore running the Solution for Site user list only and selecting System Group won't bring any meaningful result as the report will bring all Sites in your tenant.
If you want to know the access of System Group you need to select at least Site Permissions.
