Fix Teams Storage Report Does Not Match SharePoint in a Multi-Geo Tenant
🔍 WiseChecker

Fix Teams Storage Report Does Not Match SharePoint in a Multi-Geo Tenant

When you run a storage report for Teams in a multi-geo tenant, the numbers often do not match what SharePoint reports. This mismatch occurs because Teams stores files in SharePoint sites that are spread across different geographic locations. The Teams admin center shows aggregate storage, while SharePoint reports per-site detail. This article explains the root cause and gives you step-by-step fixes to reconcile the numbers.

The mismatch is not a bug. It happens because Teams storage is calculated from all SharePoint sites that back Teams channels, including those in satellite locations. The SharePoint admin center shows storage per site collection, which may exclude system or hidden sites. You will learn how to verify the correct sites, use PowerShell to get accurate totals, and adjust your reporting method.

Key Takeaways: Reconcile Teams Storage in a Multi-Geo Tenant

  • SharePoint admin center > Storage metrics: Shows per-site usage but may exclude hidden team sites.
  • Get-SPOSite -IncludePersonalSite $false: Lists all team sites including those in satellite locations.
  • Get-SPOSiteStorageManagementStatus: Confirms whether storage metrics are fully calculated for each site.

ADVERTISEMENT

Why Teams Storage Report Differs From SharePoint in Multi-Geo

In a multi-geo tenant, your data resides in a central location plus one or more satellite locations. Every Teams team has a connected SharePoint site. That site lives in the geo location where the team was created or where the group was provisioned. The Teams admin center aggregates storage from all these sites into a single number. The SharePoint admin center shows storage per site collection, and it only includes sites that are visible in the site list.

The mismatch appears for three reasons. First, the Teams storage report includes hidden system sites that SharePoint does not list by default. Second, the SharePoint storage metrics may not include sites that have not yet been indexed or that are in a satellite location. Third, Teams counts storage from all channel messages and files, while SharePoint only counts files in document libraries.

How Teams Storage Is Calculated

Each Teams team has a SharePoint site with a document library named “Documents”. All files shared in channel conversations are stored in that library. The Teams storage report sums the storage used by every document library across all team sites. This includes version history, recycle bin items, and metadata. SharePoint storage metrics for a site include the same items but only when you look at the site’s storage metrics page.

How Multi-Geo Affects the Numbers

In a multi-geo tenant, each satellite location has its own SharePoint admin center. The main SharePoint admin center shows a combined view, but it may not refresh immediately. Teams storage data is pulled from all geo locations in near real time. That timing difference can cause a temporary mismatch. Also, the Teams admin center does not let you filter by geo location, so you cannot see which site is causing the difference.

Steps to Reconcile Teams Storage With SharePoint Reports

To get matching numbers, you need to compare the correct data sources. Use the following steps to verify the sites, calculate total storage with PowerShell, and adjust your reporting.

Step 1: Identify All Teams Sites in the Tenant

  1. Sign in to the SharePoint admin center
    Go to admin.microsoft.com and open the SharePoint admin center. In the left navigation, select Sites then Active sites.
  2. Filter for team sites
    Use the search box to filter sites by the prefix “Teams” or by the site URL pattern that starts with the tenant name followed by “-my” for personal sites. Exclude personal sites.
  3. Note the site URLs
    Write down the URLs of all sites that belong to Teams teams. Include sites in satellite locations. The URL will contain the geo location code, such as “eur” for Europe.

Step 2: Get Accurate Storage Data With PowerShell

  1. Install the SharePoint Online Management Shell
    Open Windows PowerShell as an administrator. Run Install-Module -Name Microsoft.Online.SharePoint.PowerShell and press Enter.
  2. Connect to SharePoint Online
    Run Connect-SPOService -Url https://yourtenant-admin.sharepoint.com. Sign in with a global admin or SharePoint admin account.
  3. Run the storage report for all sites
    Execute Get-SPOSite -IncludePersonalSite $false | Select-Object Url, StorageUsageCurrent. This lists every site and its current storage in megabytes.
  4. Sum the storage for Teams sites
    Filter the output to include only sites that match your Teams site URLs. Add the StorageUsageCurrent values. This total should match the Teams storage report.

Step 3: Verify Storage Metrics Are Fully Calculated

  1. Check the storage metric status
    Run Get-SPOSiteStorageManagementStatus -SiteUrl https://yourtenant.sharepoint.com/sites/teamsite. If the status is “InProgress”, the site has not finished calculating storage. Wait and rerun the command.
  2. Force a recalculation
    If status remains “InProgress” for more than 24 hours, run Set-SPOSite -Identity https://yourtenant.sharepoint.com/sites/teamsite -StorageManagementStatus 1 to restart the calculation.

Step 4: Compare With the Teams Admin Center

  1. Open the Teams admin center
    Go to admin.teams.microsoft.com. Under Analytics & reports, select Usage reports.
  2. Run the Teams storage report
    Choose the report type “Teams storage” and set the date range. Download the CSV file.
  3. Compare the totals
    Add up the storage in the CSV and compare it with your PowerShell total. They should match within a few megabytes.

ADVERTISEMENT

If Teams Storage Still Does Not Match SharePoint

Even after the main steps, you may see a difference. Here are the common causes and how to fix them.

Teams Storage Report Includes Hidden System Sites

Teams creates a system site for each team that holds app data and channel metadata. SharePoint does not list this site in the active sites list. To see it, run Get-SPOSite -Template TeamChannel in PowerShell. Add the storage of these sites to your SharePoint total to match Teams.

SharePoint Report Does Not Include Satellite Locations

If your SharePoint admin center shows only the central location, you are missing storage from satellite geos. Use the SharePoint admin center for each satellite location or use PowerShell with the -GeoLocation parameter to list sites in a specific geo. Then add the storage from all locations.

Teams Storage Report Is Delayed by Up to 24 Hours

Teams storage data refreshes once a day. SharePoint storage metrics update more frequently. If you compare data from different times, the numbers will differ. Wait 24 hours after uploading files, then rerun both reports.

Teams Storage Report vs SharePoint Storage Metrics: Key Differences

Item Teams Admin Center Report SharePoint Admin Center
Data source Aggregates all Teams sites across all geo locations Shows per-site collection in the selected geo
Includes hidden system sites Yes No
Update frequency Once per day Near real time
Filter by geo location Not available Yes, per satellite admin center
Includes recycle bin and versions Yes Yes

After following these steps, you can reconcile the Teams storage report with SharePoint. Use PowerShell to get an accurate total that includes all sites and geo locations. Check the storage management status to ensure the numbers are fully calculated. For ongoing monitoring, export the Teams storage report weekly and compare it with your PowerShell baseline. Use the Get-SPOSite command to automate the reconciliation with a scheduled script.

ADVERTISEMENT