Forum Discussion

Iron Contributor

Jul 26, 2017

Solved

Get SharePoint Groups or Security Groups and Permissions for each Sub Web.

Hi I want produce a report or the SharePoint Groups and or Security Groups on each of the Sub Webs ( one level only) in an SharePoint online intranet. Now, before I start creating a custom o...

Yogendra505
Mar 13, 2020

It works --->

Connect-PnPOnline - <<Give details here>>
$context.Load($context.Web.RoleAssignments)
$context.Load($context.Web.RoleAssignments.Groups)
Invoke-PnPQuery -ErrorAction Stop
ForEach($group in $context.Web.RoleAssignments.Groups)
{
$context.Load($group)
Invoke-PnPQuery -ErrorAction Stop
$perm = Get-PnPGroupPermissions -Identity $group.Title
if($perm.Name.Count -gt 0) {
for($i=0; $i -lt $perm.Count;$i++){
Set-PnPGroup -Identity $group.Title -RemoveRole $perm[$i].Name
}
Set-PnPGroup -Identity $group.Title -AddRole "Read"
}

Daniel Westerdale

Iron Contributor

Aug 30, 2017

Robert Luck wrote:

It's AdminDroid. You can check out the interactive demo http://demo.admindroid.com.

Thanks Robert Luck the name did escape me monentarily. Ideally this should be something we should get via the PnPCommandlet esp when considering there is -Web parementer.

Yogendra505

Copper Contributor

Mar 13, 2020

It works --->

Connect-PnPOnline - <<Give details here>>
$context.Load($context.Web.RoleAssignments)
$context.Load($context.Web.RoleAssignments.Groups)
Invoke-PnPQuery -ErrorAction Stop
ForEach($group in $context.Web.RoleAssignments.Groups)
{
$context.Load($group)
Invoke-PnPQuery -ErrorAction Stop
$perm = Get-PnPGroupPermissions -Identity $group.Title
if($perm.Name.Count -gt 0) {
for($i=0; $i -lt $perm.Count;$i++){
Set-PnPGroup -Identity $group.Title -RemoveRole $perm[$i].Name
}
Set-PnPGroup -Identity $group.Title -AddRole "Read"
}