Adding a SharePoint Site Administrator Group to all Sites

In this blog post, we're talking about a PowerShell script designed to add a group as site collection administrators across all SharePoint Online sites.

Let's break down the PowerShell script:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

# Tenant name $TenantUrl = "https://yourtenant-admin.sharepoint.com/" # Get the group ID for the Entra ID group you want to add $Group = "C:0t.c|tenant|99033653-dxch-4912-83sw-e90117886144" # Connect to Sharepoint Online Admin site Connect-SPOService -Url $TenantUrl # Get all Sharepoint sites $SPOSites = Get-SPOSite # Add the group to all sites foreach ($SPOSite in $SPOSites) { Set-SPOUser -Site $SPOSite.Url -LoginName $Group -IsSiteCollectionAdmin $true -WarningAction Stop Write-Host "Added group $Group as Site Collection Administrator to $($SPOSite.Url)" }

After this all users added to the group you specified are added as a site collection admin

Of course this can also be done with individual users:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

# Tenant name $TenantUrl = "https://yourtenant-admin.sharepoint.com/" # Add a single user as siteadmin to all SPO sites $User = "username@domain.com" # Connect to Sharepoint online Connect-SPOService -Url $TenantUrl # Get all Sharepoint Online sites $SPOSites = Get-SPOSite # Add the user to all sites foreach ($SPOSite in $SPOSites) { Set-SPOUser -Site $SPOSite.Url -LoginName $User -IsSiteCollectionAdmin $true }

Adjust the following values in the Script:

1. $TenantUrl: Specifies the URL of the SharePoint Online admin site.

2. $Group: Represents the unique identifier of the group (in this case, "Entra ID group") to be added as a site collection administrator.

And there you go, now you can easily switch admins and site admins within all your SharePoint Online sites within one group.

Or add a single user in a fast and consistent way.