Hi folks!
You can reach this goal by 2 ways:
-
- via Office365 Admin Portal:
Go to Admin Portal->Reports->Usage-Click on OneDrive files.
You can click in Export and it will give you Usage in CSV:
2. Via PowerShell:
Run SharePoint Online Management Shell (download it here) and run next Cmdlet:
Get-SPOSite -Includepersonalsite:$true -Filter {Url -like “https://YOUR_TENANT_NAME-my.sharepoint.com/personal”} | select url,owner,storagequota,storageusagecurrent | Export-CSV D:\Temp\UsageRep.csv
I hope it will be saved your time.