Need a Powershell script to export the SharePoint Sites with a condition..

Question

Hi All,

I need a Powershell script to export the SharePoint Sites with a condition - Zero Members and only one Owners.

Any help would be greatly appreciated!

Regards,

SK

Answer 1

You can use this free and open source application to get a report with all the site permissions across all sites in the tenant:

https://github.com/Barbarur/NovaPoint

once the report is generated, you can filter it based on the site that doesn’t have users.

Answer 2

Hi @Santhosh Kumar,

You could use the Get-SPOSite cmdlet, which returns the site collection information, including the owner.

$SiteURL = "https://crescent-admin.sharepoint.com"
$CSVPath = "C:\Temp\SiteOwners.csv"
  
#Connect to Admin Center Site
Connect-PnPOnline -Url $SiteURL -Interactive
   
#Get All Site collections
$SiteCollections = Get-PnPTenantSite
$SiteOwners = @()
 
#Loop through each site collection
ForEach($Site in $SiteCollections)
{
     $Owners = $Site.Owner
     If($Owners.count = 1){
     Write-Output "Site:" $Site.Url
}

}

---

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.