Forum Discussion
Turning off sharing with externals on all sharepoint sites, teams and groups?
Hi,
I am looking to see if it's possible thru powershell to turn off the sharing capability of all sharepoint sites. groups and team sites?
It's very hard to go thru every 30 sharepoint sites/groups and edit bulking them when there's over 1,000.
This what I mean....
Is it possible to do in PowerShell?
Odenkaz I think so by what is described here: https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/modern-experience-customizations-provisioning-sites#provisioning-modern-team-sites
But, after reading your original post I think the problem is the default limit(200) for the output, please add the "-limit All" to the get-SPOSite cmdlet.
$AllSitesURLs = $(Get-SPOSite -Limit All | where{$_.status -eq 'Active' -and $_.Template -notlike "SPSMSITEHOST*" -and $_.Template -notlike "POINTPUBLISHINGHUB*"}).URL #You can play with the filter to set only those sites that you require $Count = $AllSitesURLs.count Write-Host 'Total Sites Gathered' $Count -Foreground Cyan Foreach($SiteURL in $AllSitesURLs) { Set-SPOSite -Identity $SiteURL -SharingCapability Disabled #Here you can set the sharing options that you consider better.https://docs.microsoft.com/en-us/sharepoint/turn-external-sharing-on-or-off } $STS3Sites = Get-SPOSite -Limit All -Template 'STS#3' #filter by template, it is easier with the template switch $AllTemplates = Get-SPOSite -Limit All | select Template -Unique # just to know what are the templates that you are using on your tenant. 😃
5 Replies
Odenkaz Hello Odenkaz. As far as I know, everything can be done through PowerShell if you try and test enough =),
Hope this solves your request:
$AllSitesURLs = $(Get-SPOSite | where{$_.status -eq 'Active'}).URL #You can play with the filter to set only those sites that you require Foreach($SiteURL in $AllSitesURLs) { Set-SPOSite -Identity $SiteURL -SharingCapability Disabled #Here you can set the sharing options that you consider better.https://docs.microsoft.com/en-us/sharepoint/turn-external-sharing-on-or-off }Regards
Erick Moreno
Erick A. Moreno R. wrote:Odenkaz Hello Odenkaz. As far as I know, everything can be done through PowerShell if you try and test enough =),
Hope this solves your request:
$AllSitesURLs = $(Get-SPOSite | where{$_.status -eq 'Active'}).URL #You can play with the filter to set only those sites that you require Foreach($SiteURL in $AllSitesURLs) { Set-SPOSite -Identity $SiteURL -SharingCapability Disabled #Here you can set the sharing options that you consider better.https://docs.microsoft.com/en-us/sharepoint/turn-external-sharing-on-or-off }Regards
Erick Moreno
Hi Erick, thank you for your reply!
I tried your snippet and got the following error:
Additionally: To filter only those with external sharing enabled i would have to add in the where clause the exact name of the column shown in the report?
Odenkaz This should filter those that are throwing the error.
$AllSitesURLs = $(Get-SPOSite | where{$_.status -eq 'Active' -and $_.Template -notlike "SPSMSITEHOST*" -and $_.Template -notlike "POINTPUBLISHINGHUB*"}).URL #You can play with the filter to set only those sites that you require Foreach($SiteURL in $AllSitesURLs) { Set-SPOSite -Identity $SiteURL -SharingCapability Disabled #Here you can set the sharing options that you consider better.https://docs.microsoft.com/en-us/sharepoint/turn-external-sharing-on-or-off }As you said, you just need to combine the attributes/columns using the format I used above and the desired state on each one to set the sharing options only for those that meet the conditions.
Regards
Erick Moreno
