Powershell script to get the Site Collection permission

Question

Is there any Powershell script to get the entire Site Collection permissions data in a Excel Sheet? Thanks!!

Rajkiran Swain · Answer

#Add SharePoint PowerShell SnapIn if not already added if ((Get-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $ null ) { Add-PSSnapin Microsoft.SharePoint.PowerShell } #Define variables $site = Get-SPSite http://  #Get all subsites for site collection $web = $site.AllWebs #Loop through each subsite and write permissions foreach ($web in $web) { if (($web.permissions -ne $ null ) -and ($web.hasuniqueroleassignments -eq True )) { Write-Output **************************************** Write-Output Displaying site permissions for: $web $web.permissions | fl member basepermissions } elseif ($web.hasuniqueroleassignments -ne True ) { Write-Output **************************************** Write-Output Displaying site permissions for: $web $web inherits permissions from $site } #Loop through each list in each subsite and get permissions foreach ($list in $web.lists) { $unique = $list.hasuniqueroleassignments if (($list.permissions -ne $ null ) -and ($unique -eq True )) { Write-Output **************************************** Write-Output Displaying Lists permissions for: $web \ $list $list.permissions | fl member basepermissions } elseif ($unique -ne True ) { Write-Output $web \ $list inherits permissions from $web } } } Write-Host Finished. $site.dispose() $web.dispose() $unique.dispose()

Waqas Sarwar · Answer

Check this http://sharepoint.stackexchange.com/questions/144110/powershell-get-permission-on-spsite-spweb-and-all-list

Prashant Kumar · Answer

Hi Please check below URL to get your result: http://sharepointpromag.com/sharepoint-2013/exploring-sharepoint-users-groups-and-security-using-powershell Thanks