You want to calculate your storage capacity in SharePoint Online? Here is how:
- Every 1TB is 1024GB (it might be confusing, see my previous post, but it’s how it is calculated)
- A tenant gets 1024GB by default
- For every user license of a product that includes the service plan called “SHAREPOINTSTANDARD”/SharePoint Online (Plan 1) you get 10 GB extra
- For every user license of a product that includes the service plan called “SHAREPOINTENTERPRISE”/SharePoint Online (Plan 2) you get 10 GB extra
- For every user license of a product that includes the service called “ONEDRIVEBASIC”/SharePoint Online OneDrive Basic you get 0.5 GB extra
Products vs. Service Plans
A product (a.k.a. SKU) consists of service plans. E.g. Office 365 E3 (product) consists of SharePoint Online Enterprise among others. It is a Service Plan that gives you additional storage, not a product. The information on “SharePoint Limits” page is (over-)simplified. Simplified for a good reason of course - to give a rule of thumb for calculating your storage.
But if you want to calculate the exact storage capacity, like I do, and even break it down into different departments etc based on licenses, then you need to be aware of the fact that a service plan makes you eligible of more space. A service plan, such as SharePoint Online (Plan 1) can be part of 1 or more products.
Service Plans eligible additional storage and the corresponding SKUs
SharePoint Online (Plan 1) - “SHAREPOINTSTANDARD” - 10 GB per user license
- Project Online Plan 1 - PROJECT_P1
- Office 365 Enterprise E1 - STANDARDPACK
SharePoint Online (Plan 2) - “SHAREPOINTENTERPRISE” - 10 GB per user license
OFFICE 365 E5 - ENTERPRISEPREMIUM
OFFICE 365 E3 - ENTERPRISEPACK
MICROSOFT 365 E3 - SPE_E3
PROJECT ONLINE ESSENTIALS - PROJECTESSENTIALS
PROJECT ONLINE PROFESSIONAL - PROJECTPROFESSIONAL
PROJECT ONLINE PREMIUM - PROJECTPREMIUM
DYNAMICS 365 CUSTOMER ENGAGEMENT PLAN ENTERPRISE EDITION - DYN365_ENTERPRISE_PLAN1
Dynamics 365 Customer Service Professional - DYN365_CUSTOMER_SERVICE_PRO
DYNAMICS 365 FOR SALES ENTERPRISE EDITION - DYN365_ENTERPRISE_SALES
DYNAMICS 365 FOR TEAM MEMBERS ENTERPRISE EDITION - DYN365_ENTERPRISE_TEAM_MEMBERS
“ONEDRIVE_BASIC” - 0.5 GB per user license
- VISIO Online Plan 2 - VISIOCLIENT
- VISIO ONLINE PLAN 1 - VISIOONLINE_PLAN1
ActiveUnits vs. WarningUnits vs. ConsumedUnits
You can ignore the ConsumedUnits, because they are not used in the storage calculation. The ActiveUnits are the ones that are purchased. The WarningUnits are the licenses that have not been renewed and will be removed after 30 days.
So you need to count both the ActiveUnits and WarningUnits. Licenses = ActiveUnits + WarningUnits.