kwizcom banner advertisement

Find All OneDrive Site Collections in SharePoint Online using PowerShell

April 23, 2018    , , , ,
Requirement: Get a list of all OneDrive site collections from SharePoint Online. I was asked to get the list of all OneDrive sites to get the usage of OneDrive for Business in our Office 365 tenant. Its bit tricky to find all of your OneDrive site collections and here is how I achieved using Get-SPOSite cmdlet: Find All OneDrive Sites using SharePoint Online Management Shell: Here is the PowerShell script to get all OneDrive site collections in SharePoint Online. $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 and export to a Text file Get-SPOSite -Template "SPSPERS" -limit ALL -includepersonalsite $True | Select URL, Owner | Format-table -autosize | Out-string -width 8096 | Out-file C:\temp\OneDriveSites.txt Just change the $AdminSiteURL t
Find All OneDrive Site Collections in SharePoint Online using PowerShell Find All OneDrive Site Collections in SharePoint Online using PowerShell Reviewed by Salaudeen Rajack on April 23, 2018 Rating: 5
Powered by Blogger.