The solution below requires only SharePoint Online Management Shell :
1. Connect to Sharepoint Online:
Connect-SPOService -Url https://tenantname-admin.sharepoint.com
2. Get logins list you need to build report:
Ex. from existing Sharepoint Online tenant
$logins=(Get-SPOUser -Site https://tenantname-my.sharepoint.com).LoginName
or from external source Logins.csv
$logins = (import-csv logins.csv).Identity
where CSV-file content just like:
Identity
user1@domain.com
user2@domain.com
user3@domain.com
user4@domain.com
user5@domain.com
3. Build full usage report and export to CSV file:
All pieces together in single PowerShell script:
Reference:
Create OneDrive for Business usage report using Powershell
user1@domain.com
user2@domain.com
user3@domain.com
user4@domain.com
user5@domain.com
3. Build full usage report and export to CSV file:
foreach ($login in $logins) {
if($Login.Contains('@')) {
$login=$login.Replace('@','_');
$login=$login.Replace('.','_');
$login=$login.Replace('.','_');
$login="https://tenantname-my.sharepoint.com/personal/"+$login;
$Report = Get-SPOSite -Identity $login -ErrorAction SilentlyContinue
$Report | Export-CSV ODFB-CSV-Report.csv -Append}
}
All pieces together in single PowerShell script:
# enter tenantname (ex. if appriver3651004263.onmicrosoft.com)
$tenant="appriver3651004263"
# Connect to Sharepoint Online:
Connect-SPOService -Url https://$($tenant)-admin.sharepoint.com
# Get logins list you need to build report: Ex. from existing Sharepoint Online tenant
$logins=(Get-SPOUser -Site https://$($tenant)-my.sharepoint.com).LoginName
# or from external source Logins.csv
# $logins = (import-csv logins.csv).Identity
foreach ($login in $logins) {
if($Login.Contains('@')) {
$login=$login.Replace('@','_');
$login=$login.Replace('.','_');
$login=$login.Replace('.','_');
$login="https://$($tenant)-my.sharepoint.com/personal/"+$login;
$Report = Get-SPOSite -Identity $login -ErrorAction SilentlyContinue
$Report | Export-CSV ODFB-CSV-Report.csv -Append -NoTypeInformation}
}
Create OneDrive for Business usage report using Powershell
Many thanks for sharing this very diverse opinion post where each expert has no doubt shared his best knowledge on the topic.Install Uc Browser and get 20 GB secure cloud storage in your mobile.
ReplyDeleteBest free cloud storage for personal use