Forum Discussion

KEGAN1975's avatar
KEGAN1975
Brass Contributor
Aug 03, 2017

Report on list of all users and what they have access to for a SharePoint site

Hello, had a request off a site owner for a list of all users and what they have access to for a SharePoint online team site, is there any way of doing this?

 

cheers

Permissions
SharePoint Online
Sites
  • Ella Mayr's avatar
    Ella Mayr
    Copper Contributor
    Sep 05, 2017

    Hi Kevin. When it comes to unique users, their activities, and what they have access to, a third party tool is needed to get involved. Cardiolog Analytics is a thirdparty analytics tool designed to connect with all versions of SharePoint and Office365 intranet portals. It provides a veriety of detail oriented analytics that track activity in your portal down to the specific user activity.  With Cardiolog you would be able to know who has access to which site, how often each user viewed the site and much more. For more information and for the opportunity to book a free demo go to intlock.com 

  • Gregory Frick's avatar
    Gregory Frick
    Steel Contributor
    Aug 03, 2017

    KEGAN1975 - This has always been a gap with SharePoint.  We use a third party tool (Sharegate) to fill this gap. When I export the Sharegate permissions matrix report to excel, I end up with a sheet with the following column headings:

    Row #
    Type
    Name
    URL
    Item Path
    Inheritance
    Details
    User/Group
    Principal Type
    Account Name
    Given Through
    Full Control
    Design
    Contribute
    Edit
    Read
    View Only
    Approve
    Manage Hierarchy
    Restricted Read
    Restricted Interfaces for Translation
    Public-Add


    This report can consist of thousands of rows depending on how many securable objects are in your site collection and how many objects have custom permissions (vs. inherited).  Generally a business user will not want to try to read this report, I will provide it for the record, but they usually follow up with a more specific question such as "Do these people have access to this stuff?" and I help them figure that out.  

     

    You also apply a filter to display the report based on particular users or SharePoint groups. 

     

    If you look around you will find some examples of Powershell for getting some of this information, but you will have your hands full creating a complete report.

     

    We have found Sharegate to be indispensible for this and many other tasks. I am sure there are other tools that perform equally as well or maybe better, but Sharegate was easier for us to purchase because of the cost and how they price their tool. 

     

     

     

     

     

     

     

     

     

     

Resources