SharePoint 2013 Hosting – HostForLIFE.eu : How To Get All The Lists Which Have Unique Permissions From the Sharepoint Online Site Using PnP PowerShell

In this blog, you will see how to get all the lists which have unique permissions from the root site as well as sub sites using PnP PowerShell.

You can download setup files from the releases section of the PnP PowerShell repository. Copy the below script and paste it in a notepad. Save the file as GetUniquePermissions.ps1.

# Input Parameters  
$siteURL="https://c986.sharepoint.com/sites/dev"  
  
# foLoop through all the lists and check if the list has unique permissions  
Function GetUniquePermissions($web)  
{  
    $listColl=Get-PnPList -Web $web -Includes HasUniqueRoleAssignments     
    foreach($list in $listColl)  
    {    
        if($list.HasUniqueRoleAssignments)  
        {  
            write-host -ForegroundColor Yellow $list.Title " has unique permissions"  
        }        
    }      
}  
  
# Get the root web and call the GetUniquePermissions function  
Function GetRootWeb()  
{  
    $rootWeb=Get-PnPWeb      
    write-host -ForegroundColor Magenta "Getting information from the website - " $rootWeb.Title " - " $rootWeb.Url  
    GetUniquePermissions($rootWeb);  
}  
  
# Get the all the sub webs and call the GetUniquePermissions function  
Function GetSubWebs()  
{  
    $webColl=Get-PnPSubWebs -Recurse      
    foreach($web in $webColl)  
    {      
        write-host -ForegroundColor Magenta "Getting information from the website - " $web.Title " - " $web.Url  
        GetUniquePermissions($web);  
    }  
}  
  
# Connect to SharePoint Online site  
Connect-PnPOnline –Url $siteURL –Credentials (Get-Credential)  
  
# Call the functions  
GetRootWeb  
GetSubWebs

# Input Parameters

$siteURL="https://c986.sharepoint.com/sites/dev"

# foLoop through all the lists and check if the list has unique permissions

Function GetUniquePermissions($web)

{

$listColl=Get-PnPList -Web $web -Includes HasUniqueRoleAssignments

foreach($list in $listColl)

{

if($list.HasUniqueRoleAssignments)

{

write-host -ForegroundColor Yellow $list.Title " has unique permissions"

}

# Get the root web and call the GetUniquePermissions function

Function GetRootWeb()

{

$rootWeb=Get-PnPWeb

write-host -ForegroundColor Magenta "Getting information from the website - " $rootWeb.Title " - " $rootWeb.Url

GetUniquePermissions($rootWeb);

}

# Get the all the sub webs and call the GetUniquePermissions function

Function GetSubWebs()

{

$webColl=Get-PnPSubWebs -Recurse

foreach($web in $webColl)

{

write-host -ForegroundColor Magenta "Getting information from the website - " $web.Title " - " $web.Url

GetUniquePermissions($web);

}

# Connect to SharePoint Online site

Connect-PnPOnline –Url $siteURL –Credentials (Get-Credential)

# Call the functions

GetRootWeb

GetSubWebs

Open PowerShell window and run the following command.

>cd "<folderlocation>"

1	>cd "<folderlocation>"

folderlocation – GetUniquePermissions.ps1 file location

Run the following command

>.\GetUniquePermissions.ps1

1	>.\GetUniquePermissions.ps1

Thus in this blog, you saw how to get all the lists which have unique permissions from the SharePoint online site using PnP PowerShell.

Print article

This entry was posted by Peter on August 9, 2018 at 7:09 am, and is filed under European SharePoint 2013 Hosting. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site.

SharePoint 2013 Hosting – HostForLIFE.eu : How To Get All The Lists Which Have Unique Permissions From the Sharepoint Online Site Using PnP PowerShell

BLOGROLL

Featured On

SharePoint 2013 Hosting – HostForLIFE.eu : How To Get All The Lists Which Have Unique Permissions From the Sharepoint Online Site Using PnP PowerShell

BLOGROLL

Featured On

Tags