Is there a PowerShell script that gets all SharePoint sites and the owners of the site

MDuBose 716

Using the PowerShell commands below, it lists all sites and sub sites including the title, author and url of those site. However, the author property returns the user who created the site not the site owner.

Write-Host("Getting Site Data")

Get-SPSite | Get-SPWeb -Limit All | select Title, Author, Url

I've also tried the command below but Owner returns empty.

Write-Host("Getting Site Data")

Get-SPSite | Get-SPWeb -Limit All | select Title, Author, Url, Owner, @{Expression={$_.Owner}}

Is there a property where I can get the site owner of a site?

Costa, Randy 0 Reputation points

2024-08-27T19:14:26.5266667+00:00

This is fabulous. The only problem we have is that we have many Azure Groups that are owners as we have a couple of owners per site. It does not seem to return who the owners are if a group is an owner.

1 answer

ChengFeng - MSFT 5,020 Reputation points Microsoft Vendor

2023-09-19T07:02:17.8533333+00:00
Hi @ MDuBose

The Author property of the Get-SPWeb cmdlet returns the user who created the site, not the site owner. To get the site owner, you need to use the Get-SPOSite cmdlet, which returns the site collection information, including the owner.

If you want to get the site owner of a SharePoint Online site, you can use the following PowerShell script:

#Variables for Admin Center & Site Collection URL $AdminCenterURL = “https://<TenantName>-admin.sharepoint.com/” $SiteURL = “https://<TenantName>.sharepoint.com/sites/<SiteName>” #Connect to SharePoint Online Connect-SPOService -url $AdminCenterURL -Credential (Get-Credential) #Get Site Owner Get-SPOSite $SiteURL | Select Owner

This script will connect to your SharePoint Online admin center and then get the owner of the specified site collection.

If you want to get the site owner of all SharePoint Online sites, you can use this script:

$AdminCenterURL = “https://<TenantName>-admin.sharepoint.com/” #Connect to SharePoint Online Connect-SPOService -url $AdminCenterURL -Credential (Get-Credential) #Get Site owners of all site collections Get-SPOSite -limit ALL | Select URL, Owner

This script will connect to your SharePoint Online admin center and then get the URL and owner of all site collections.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best Regards

Cheng Feng
Please sign in to rate this answer.
MDuBose 716 Reputation points

2023-09-19T16:42:37.3066667+00:00

Hi @ChengFeng - MSFT ,

My environment is a SharePoint 2016 server on-premises. The script you provided is for SharePoint Online. Is there a cmdlet for on-premises environment?

ChengFeng - MSFT 5,020 Reputation points Microsoft Vendor

2023-09-20T08:58:24.2133333+00:00

Hi @ MDuBose

This is a code example, please use this code in administrator mode (the code needs to be modified according to your situation)

#Get all site collections $SiteCollections = Get-SPSite -Limit All #Loop through each site collection foreach ($SiteCollection in $SiteCollections) { #Get the site owner $Owner = Get-SPSiteAdmin -Site $SiteCollection | Where-Object {$_.IsSiteOwner -eq $true} #Get the site users $Users = Get-SPOUser -Site $SiteCollection #Get the sub sites $SubSites = Get-SPWeb -Site $SiteCollection -Limit All #Loop through each sub site foreach ($SubSite in $SubSites) { #Get the sub site owner $SubOwner = Get-SPSiteAdmin -Web $SubSite | Where-Object {$_.IsSiteOwner -eq $true} #Get the sub site users $SubUsers = Get-SPOUser -Web $SubSite #Output the sub site details Write-Output "Title: $($SubSite.Title)" Write-Output "URL: $($SubSite.Url)" Write-Output "Owner: $($SubOwner.DisplayName)" Write-Output "Users: $($SubUsers.DisplayName -join ', ')" Write-Output "" } #Output the site collection details Write-Output "Title: $($SiteCollection.RootWeb.Title)" Write-Output "URL: $($SiteCollection.Url)" Write-Output "Owner: $($Owner.DisplayName)" Write-Output "Users: $($Users.DisplayName -join ', ')" Write-Output "" }

I hope this helps you with your query. If you have any further questions, please let me know.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best Regards

Cheng Feng

ChengFeng - MSFT 5,020 Reputation points Microsoft Vendor

2023-10-06T03:21:51.7+00:00

Hi @ MDuBose

I am kindly following up to see if you have any remaining questions or concerns for this issue. Please feel free to reach us if any questions or concerns you may have. If the answer is helpful, please click "Accept Answer" and kindly upvote it.By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

ChengFeng - MSFT 5,020 Reputation points Microsoft Vendor

2023-10-06T03:36:16.5833333+00:00

Hi @ MDuBose

I am kindly following up to see if you have any remaining questions or concerns for this issue. Please feel free to reach us if any questions or concerns you may have. If the answer is helpful, please click "Accept Answer" and kindly upvote it.By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

ChengFeng - MSFT 5,020 Reputation points Microsoft Vendor

2023-10-10T01:14:04.18+00:00

Hi @ MDuBose

I am kindly following up to see if you have any remaining questions or concerns for this issue. Please feel free to reach us if any questions or concerns you may have. If the answer is helpful, please click "Accept Answer" and kindly upvote it.By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

MDuBose 716 Reputation points

2023-10-10T14:07:03.91+00:00

Hi @ChengFeng - MSFT

Thank you for providing the updated script. However, this script does not work for my environment. Get-SPSiteAdmin and Get-SPOUser cmdlets are not recognized in SharePoint Server 2016.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Is there a PowerShell script that gets all SharePoint sites and the owners of the site

1 answer

Your answer