Different reporting methods in same tenant surface different OneDrive totals

Question

When I execute Get-SPOSite "All" -IncludePersonalSites against a tenant it returns 1,526 total OneDrives. However, the total OneDrives reported in M365 Admin Center > Usage > OneDrives > Accounts is 1,090. The total returned by M365 Usage reporting is what I expected, given the total number of user accounts currently in our AAD. However, the basis for the total returned by Get-SPOSite is unclear. I would like to know why there is a difference in the total number of tenant OneDrives reported by these two methods, thank you.

Answer 1

Hi Stephan Bren, it is a pleasure to be able to help you : )

Per my test, you can try below cmdlets to find all OneDrive sites:

$AdminSiteURL="https://crescent-admin.sharepoint.com"
 
#Get Credentials to connect to SharePoint Admin Center
$Cred = Get-Credential
 
#Connect to SharePoint Online Admin Center
Connect-SPOService -Url $AdminSiteURL -credential $Cred
 
#Get all Personal Site collections
Get-SPOSite -Template "SPSPERS" -limit ALL -includepersonalsite $True

Hope this helps.

Best Regards.

---

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.