List site collection owners¶
Author: Patrick Lamber
This script helps you to list and export all site collection owners in your SharePoint Online sites.
$fileExportPath = "<PUTYOURPATHHERE.csv>" $m365Status = m365 status if ($m365Status -eq "Logged Out") { # Connection to Microsoft 365 m365 login } $results = @() Write-host "Retrieving all sites..." $allSPOSites = m365 spo site classic list -o json | ConvertFrom-Json $siteCount = $allSPOSites.Count Write-Host "Processing $siteCount sites..." #Loop through each site $counter = 0 foreach($site in $allSPOSites){ $counter++ Write-Host "Processing $($site.Url)... ($counter/$siteCount)" $users = m365 spo user list --webUrl $site.Url -o json | ConvertFrom-Json $owners = $users.value | where { $_.IsSiteAdmin -eq $true } foreach($owner in $owners){ $results += [pscustomobject][ordered]@{ SiteUrl = $site.Url LoginName = $owner.LoginName Title = $owner.Title Email = $owner.Email } } } Write-Host "Exporting file to $fileExportPath..." $results | Export-Csv -Path $fileExportPath -NoTypeInformation Write-Host "Completed."
Keywords:
- SharePoint Online
- Governance