Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
iconfalse
titleDescription

Find all Site Owners and the sites they have access to.

Step-by-step guide

The SharePoint Essentials Toolkit has different ways to generate SharePoint Group reports, such as Site Owner reports. You may need to find all members within all SharePoint Owners groups (or even all users within Members or Visitors Groups, or custom SharePoint Groups).

Alternatively you may need to find all SharePoint Groups with no users or many users. 

Method 1: Using 'SharePoint Groups' Report

This is the simplest way to get all SharePoint Group members and filter to only report on specific user(s) or accounts.

  1. Start the SharePoint Essentials Toolkit
  2. Select the sites that you wish to include in the report (in this case I selected 17 sites)

    Image Added

  3. Right click and select "Create Reports→Permissions Report"
  4. This will bring up the Job Options page, select "SharePoint Groups" to capture this information

    Image Added

  5. Unselect any other options you may not need or select all of them
  6. Click "Run Now" button
  7. Let the report run, you can minimize the SharePoint Essentials Toolkit and let it run. It will notify you with a pop up when the job is complete.
  8. Once complete you can select "SharePoint Group"

    Image Added

  9. Alternatively, from the Home Page Dashboard, you can right click any of the sites, and select View Reports→SharePoint Groups.

    Image Added

  10. Either method above will open the SharePoint Group Report, see below

    By default it will show you all groups within every site. You can drag and drop to alter the way this report is displayed, such as by dragging "Site URL" down to column headers

    Image Added

  11. Change the View to 'SharePoint Group Members' and you can see a list of the members. This report lists all SharePoint Groups and members, even ones that are not assigned or have no permission yet granted.

    Image Added

  12. If you need to see SharePoint Group Permissions, then you can also use one of the options below.



    NOTE: SharePoint Group Owners are identified like below:

    In the SharePoint Groups Report:

    Image Added

    In the Permission Matrix Report:
    Image Added

Method 2: Using 'Check User Permissions' Report

Use this method if you want to find where a specific account has access (all or any type of SharePoint Group for a specific account) and then filter to see where the account is a SharePoint Site Owner (member of Owners group).

  1. Start the SharePoint Essentials Toolkit
  2. Select the sites that you wish to include in the report (in this case I selected 17 sites)
    Image Removed
    Image Added

  3. Right click and select "Create Reports→Check User Permissions"
  4. Enter the name of the account such as 'Abbot Jensen'
    Image Removed
    Image Added

  5. Click "Run Now"
  6. The Job will start and once it is complete you can view the report
  7. Expand 'Sites' these are all of the sites this user has access to.
  8. Right click 'Granted Through' header and select 'Filter Editor'
    Image Removed
    Image Added

  9. Update the filter to below to filter to show Owners groups

    NOTE: SharePoint Groups denoted with (Owners) (Members) (Visitors) identify those associated groups (alternatively you could also filter by Permission Level column to  = Full Control)
    Image Removedfor the site.

    Example "IT Portal (Owners)" = The SharePoint Owners group for the "IT Portal" site.
    You can use filter "(Owners)" or "Owner" as below:

    Image Added

You can sort as you would like to display the results
10. You can now view all of the sites the user has access to and the permission level granted

...

Image Added
11. You can click Save View above to save this view to use later.

Method

...

3: Permissions - Site Permission Report

1. Repeat steps 1-3 above
2. Right click and select "Create Reports→Permissions"
3. You should see the screen below, Click Run Now

...


Image Added

4. The Active Logs window will appear to show you progress
5. Once the report is complete, you will see the following screen, click 'Site Permissions' button.

...


Image Added

6. Drag the 'Display Name' column up to group by it (by user)

...

Image Added

7. Drag 'Granted Through' column up
8. Right click 'Granted Through' column and select 'Filter Editor'

...


Image Added

9. Filter so we only show 'Owners' groups: Granted through contains 'Owners'

...

(or "(Owners)")


Image Added

10. Drag and move columns to match below

...

Image Added

11. You can click Save View above to save this view to use later.
12. NOTE: We can also right click on the item to remove access using the SharePoint Essentials Toolkit

...

Image Added

Related articles

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@958
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ( "sharepoint" , "clean" , "user" , "permissions" , "up" ) and type = "page" and space = "KC"
labelsClean up user permissions sharepoint

...