Current audit log of all user access for files/folders in SharePoint/Teams O365

Colin Richards 1 Reputation point

Im required to generate a report of all users that have access to our SharePoint and Teams? where do I find this in the reports? or how would this be recommended to be done?

Have the requirement to list which users have access to what information within our Teams/SharePoint environments, besides the Owner and Member permissions, we also have custom permissions this we would like to report on. found some auditing available on changes, but hadnt located a current actual.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,755 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Shane Townsend 1 Reputation point

    You can use this Powershell to get all users permission detials:

    foreach ($site in  ($sites = Get-SPOSite -limit All)) {
    $users = Get-SPOUser -Site $site
    foreach ($user in $users){
        $data = [PSCustomObject]@{
            "Site Url" = $site.url
            "User Login" = $user.loginname
            "Groups" = $user.Groups
            "User Type" = $user.usertype
    $data | Export-Csv -Append -NoTypeInformation c:\temp\spo-output.csv 

    Minimum required permissions for searching audit logs are View-Only Audit Logs & Audit Logs roles.

    Audit log search is accessed from the Office 365 Security & Compliance Center. You can also use the following direct link to this feature:

    Additionally, Lepide Office 365 Auditing solution tracks all changes made to Office 365 (including Exchange Online, SharePoint Online, Azure AD and OneDrive for Business) configurations, permissions, users, logins and more.

  2. Anonymous

    Sharepoint is not currently supported here on QnA. They're actively answering question in dedicated forums here.

    --please don't forget to Accept as answer if the reply is helpful--

    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    0 comments No comments