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