Extracting the site owner's information from the default "owner" group across all site collections without throttling

Question

Extracting the site owner's information from the default "owner" group across all site collections without throttling

JAGANRAJ J 0

I have a query regarding SharePoint Online management. There is a requirement to identify unused SharePoint online sites over a specific period (e.g., the last 90 or 180 days). The objective is to target these sites and extract the corresponding site owners’ details—preferably via the default Site Owners group—in order to communicate with them and determine whether their sites need to be retained or can be considered for deletion.

We are looking for a PowerShell script or Graph-based script or any other inbuild solution with in o365 that can:

Identify sites unused over a defined period

Retrieve owner information for these sites using only SharePoint Admin and Exchange Admin privileges

Operate reliably without throttling or access issues

Any guidance, script references, or best practices from the community would be greatly appreciated.

Looking forward to your expert advice.

1 answer

Your answer

Answer 1

Dear @JAGANRAJ J,

Good day! Thank you for posting your question in the Microsoft Q&A forum.

We apologize for any inconvenience you may encounter when using our services/ products. Based on your description, kindly try these following steps:

1. Install Required Modules (if not already installed)

Install-Module -Name Microsoft.Online.SharePoint.PowerShell -Force
Install-Module -Name AzureAD -Force

2. Import the Modules (if needed)

Import-Module Microsoft.Online.SharePoint.PowerShell
Import-Module AzureAD

3. Connect the Modules

$AdminCenterURL = https://yourtenant-admin.sharepoint.com
Connect-SPOService -Url $AdminCenterURL
Connect-AzureAD

Replace yourtenant with the prefix of your Microsoft 365 domain

Navigate Home - SharePoint admin center
The red box will be your tenant's name

4. Set the CSV Path Variable

$CSVPath = "C:\Temp\SiteOwners.csv"

5. Create Folder to make sure it work

New-Item -ItemType Directory -Path "C:\Temp" -Force

6. Run the Script

$Sites = Get-SPOSite -Limit ALL
 
$SiteOwners = foreach ($site in $Sites) {
    $ownerList = if ($site.Template -like "GROUP") {
        Get-AzureADGroupOwner -ObjectId $site.GroupId | Select-Object -ExpandProperty UserPrincipalName
    } else {
        $site.Owner
    }
 
    [PSCustomObject]@{
        'Site Title' = $site.Title
        'URL'        = $site.Url
        'Owner(s)'   = $ownerList -join '; '
    }
}
 
$SiteOwners | Export-Csv -Path $CSVPath -NoTypeInformation

7. For unused sites

$CSVPath1 = "C:\Temp\UnusedSites.csv" 
$sites = Get-SPOSite -Limit All  
$unusedSites = $sites | Where-Object { $_.LastContentModifiedDate -lt (Get-Date).AddDays(-90) }
$unusedSites | Select URL, Owner | Export-Csv $CSVPath1 -NoTypeInformation

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.

User's image

Huy-K 1,860 Reputation points Microsoft External Staff Moderator

2025-08-10T23:58:11.76+00:00

Dear @JAGANRAJ J,

We hope you're doing well. We just wanted to follow up and see if the solution we provided helped resolve the issue you were facing.

We haven’t heard back from you yet, and we want to make sure everything is working smoothly on your end. If you’re still experiencing any difficulties or have any questions, please don’t hesitate to reach out—we’re here to help.

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.
Huy-K 1,860 Reputation points Microsoft External Staff Moderator

2025-08-12T00:26:46.07+00:00

Dear @JAGANRAJ J,

This is our second follow-up to ensure that your issue has been resolved. Our goal is to make your experience as smooth and seamless as possible. If the issue persists or if you encounter any new challenges, we kindly ask that you share more details about the steps you are currently taking. We are always happy to assist whenever needed.

While we await your response, we will continue monitoring other customer inquiries on the forum to provide support where needed. Should you have any further questions or updates, please feel free to tag @Huy-K in your reply so we can respond promptly and thoroughly.

We look forward to hearing from you soon.

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.

Share via

Extracting the site owner's information from the default "owner" group across all site collections without throttling

1 answer

Your answer