3 min to read
How to set OneDrive for Business Storage Quota using PowerShell
Even though OneDrive for Business comes with 1TB of personal storage (by default) for every Office 365 user, several organizations have requested the ability to set smaller storage quota to limit the amount of data stored for information protection reasons and also to limit the OneDrive content from occupying local drive during sync operation. In this blog, we share the steps for setting OneDrive storage quota using PowerShell.
Before starting the process, download and install the SharePoint Online Management Shell from this link and execute the following PowerShell Scripts as Global administrator in the SharePoint Online Management Shell by connecting to SharePoint Online.
Also ensure that the SharePoint online setting “Site Collection Storage Management” is set as Manual.
You can download the scripts from here.
How to set OneDrive Storage Quota for all Office 365 Users
Input Parameters Required $Fulldomain - Office 365 domain name (Example: tenantname.com or tenantname.onmicrosoft.com) $Quota - Value for OneDrive Storage Quota (MB)
Following PowerShell script is used to set OneDrive Storage Quota for all Office 365 Users,
Step1: Get values for input parameters:
$Fulldomain="tenantname.onmicrosoft.com"
$Quota="4096"
Step2: Connect to SharePoint Online and MsolService:
$credential = get-credential
Connect-SPOService -Url “https://tenantname-admin.sharepoint.com/” -Credential $credential
Connect-MsolService -Credential $credential
Step3: Set OneDrive Storage Quota for all Office 365 Users:
$users=Get-MsolUser
$users | Foreach-Object{
$user=$_
$username=($user.userprincipalname –Split “@”)[0]
$Dname=($Fulldomain -Split "\.")
If($Dname[2] -ne $null)
{
$Firstname=$Dname[0]
$Secondname=$Dname[1]
$thirdname=$Dname[2]
$sitename= "https://"+$Firstname+"-my.sharepoint.com/personal/"+$username+"_"+$Firstname+"_"+$Secondname+"_"+$thirdname
}
Else
{
$Firstname=$Dname[0]
$Secondname=$Dname[1]
$sitename= "https://"+$Firstname+"-my.sharepoint.com/personal/"+$username+"_"+$Firstname+"_"+$Secondname
}
Set-SPOSite –Identity “$sitename” -StorageQuota $Quota
}
NOTE: During the execution of above script, for some users you may receive – “Set-SPOSite : Cannot get site https://tenantname-my.sharepoint.com/personal/username_tenantname_onmicrosoft_com.”, which occurs, when that particular user account does not have valid license or never connected to OneDrive. But the storage quota will be successfully set for valid users.
How to set OneDrive Storage Quota for Group Members
Input Parameters Required $Fulldomain - Office 365 domain name (Example: tenantname.com or tenantname.onmicrosoft.com) $Quota - Value for OneDrive Storage Quota (MB) $GroupName - Security Group
NOTE: Security Group is used for controlling OneDrive and SharePoint access and for Mobile Device Management for Office 365.
Following PowerShell script is used to set OneDrive Storage Quota for Group Members,
Step1: Get values for input parameters:
$Fulldomain="tenantname.onmicrosoft.com"
$Quota="7168"
$GroupName =”TestGroup”
Step2: Connect to SharePoint Online and MsolService:
$credential = get-credential
Connect-SPOService -Url “https://tenantname-admin.sharepoint.com/” -Credential $credential
Connect-MsolService -Credential $credential
Step3: Set OneDrive Storage Quota for Group Members:
$Group = Get-MsolGroup |Where-Object{$_.DisplayName -like $GroupName}
$members = Get-MsolGroupMember -GroupObjectId $Group.ObjectId
$members | Foreach-Object{
$member = $_
$username=($member.EmailAddress -Split "@")[0]
$Dname=($Fulldomain -Split "\.")
If($Dname[2] -ne $null)
{
$Firstname=$Dname[0]
$Secondname=$Dname[1]
$thirdname=$Dname[2]
$sitename= "https://"+$Firstname+"-my.sharepoint.com/personal/"+$username+"_"+$Firstname+"_"+$Secondname+"_"+$thirdname
}
Else
{
$Firstname=$Dname[0]
$Secondname=$Dname[1]
$sitename= "https://"+$Firstname+"-my.sharepoint.com/personal/"+$username+"_"+$Firstname+"_"+$Secondname
}
Set-SPOSite –Identity $sitename -StorageQuota $Quota
}
How to set OneDrive Storage Quota for Bulk Office 365 users via CSV file
Following PowerShell script is used to set OneDrive Storage Quota for Bulk Office 365 users via CSV file,
Step1: Connect to SharePoint Online and MsolService:
$credential = get-credential
Connect-SPOService -Url “https://tenantname-admin.sharepoint.com/” -Credential $credential
Connect-MsolService -Credential $credential
Step2: Set OneDrive Storage Quota for Bulk Office 365 users via CSV file:
$csv = Import-Csv D:\foldername\StorageQuota.csv
foreach ($line in $csv)
{
$username=($Line.UserPrincipalname -Split "@")[0]
$Fulldomain =($Line.UserPrincipalname -Split "@")[1]
$Dname=($Fulldomain -Split "\.")
$Quota=[convert]::ToInt32($Line.Quota)
If($Dname[2] -ne $null)
{
$Firstname=$Dname[0]
$Secondname=$Dname[1]
$thirdname=$Dname[2]
$sitename= "https://"+$Firstname+"-my.sharepoint.com/personal/"+$username+"_"+$Firstname+"_"+$Secondname+"_"+$thirdname
}
Else
{
$Firstname=$Dname[0]
$Secondname=$Dname[1]
$sitename= "https://"+$Firstname+"-my.sharepoint.com/personal/"+$user.name+"_"+$Firstname+"_"+$Secondname
}
Set-SPOSite –Identity $sitename -StorageQuota $Quota
}
Sample CSV File
