Get-SPOSite -IncludePersonalSite $true: include OneDrive sites in the list

Get-SPOSite -IncludePersonalSite $true adds OneDrive (personal) sites to the output of Get-SPOSite. By default they are excluded: the reference says "The values are $true and $false. By default, the value is $false which means no personal sites will be returned." Combine it with -Limit All, because OneDrive sites usually outnumber SharePoint sites and the default limit of 200 is reached quickly.

Connect-SPOService -Url https://contoso-admin.sharepoint.com
Get-SPOSite -IncludePersonalSite $true -Limit All `
  -Filter "Url -like '-my.sharepoint.com/personal/'" |
  Select-Object Url, Owner, StorageUsageCurrent

A Boolean, not a switch

Unlike most "include" options in PowerShell, this parameter is a nullable Boolean. Writing -IncludePersonalSite without a value, or with a word like yes, does not work. Checked offline in Windows PowerShell 5.1 with module 16.0.27709.12000:

Import-Module Microsoft.Online.SharePoint.PowerShell -DisableNameChecking
$p = (Get-Command Get-SPOSite).Parameters['IncludePersonalSite']
"Type: " + $p.ParameterType.Name + " of " + $p.ParameterType.GenericTypeArguments[0].Name
try { Get-SPOSite -IncludePersonalSite yes -ErrorAction Stop } catch { $_.Exception.Message }
try { Get-SPOSite -IncludePersonalSite $true -Limit All -ErrorAction Stop } catch { $_.Exception.Message }

Type: Nullable`1 of Boolean
Cannot convert 'System.String' to the type 'System.Nullable`1[System.Boolean]' required by parameter 'IncludePersonalSite'.
No connection available. Use Connect-SPOService before running this CmdLet.

The first call fails while binding the parameter; the second binds correctly and only fails because there is no Connect-SPOService session (No connection available).

Related options

Pitfalls

• Default limit. Without -Limit All you get at most 200 sites in total; see Get-SPOSite -Limit All.
• Permissions on the data. Listing OneDrive sites needs the SharePoint Administrator role; it does not give access to the files in them.
• Properties. With -Limit, some properties are not populated; storage values for many sites are better read as shown on storage usage.
• Deleted users. Retention of orphaned OneDrive sites is controlled by OrphanedPersonalSitesRetentionPeriod.

FAQ