SharePoint Storage Report

Storage consumption analysis across all SharePoint Online sites. Track usage by site type, identify sites approaching quotas, and plan storage capacity.

Overview

The SharePoint Storage Report provides detailed analysis of storage consumption across your SharePoint Online environment. Monitor site-level storage usage, identify growth trends, and manage quota allocation to optimize your storage investment.

Report Columns

Column	Description
Site Name	SharePoint site display name
Site URL	Full URL of the SharePoint site
Site Type	Team Site, Communication Site, Hub Site, or Personal
Storage Used	Current storage consumption
Storage Quota	Allocated storage quota
Quota Used %	Percentage of quota consumed
File Count	Total number of files in the site
Last Activity	Date of most recent site activity
Owner	Primary site owner

Storage by Site Type

Site Type	Description
Team Sites	Sites connected to Microsoft 365 Groups and Teams
Communication Sites	Intranet and publishing sites
Hub Sites	Sites that organize other sites into a hub
Personal (OneDrive)	Individual OneDrive for Business sites

Sites Approaching Quota

The report highlights sites at risk of running out of storage:

Critical (95%+) — Immediate action needed to increase quota or clean up
Warning (85-95%) — Site will reach capacity soon at current growth rate
Caution (75-85%) — Monitor growth and plan for expansion

Warning: Sites that reach their storage quota will prevent users from uploading new files. Proactively manage storage to avoid disruption.

Inactive Sites

Identify sites consuming storage with no recent activity:

Inactivity Period	Site Count	Recommendation
90-180 days	Varies	Review with site owner
180-365 days	Varies	Archive candidate
Over 365 days	Varies	Delete candidate

Filters

Site Type — Team, Communication, Hub, Personal
Storage Range — Filter by usage amount or percentage
Activity — Active, Low activity, Inactive
Tenant — Filter by managed tenant
Date Range — For trend analysis

Graph API Data Sources

GET /reports/getSharePointSiteUsageStorage
GET /reports/getSharePointSiteUsageDetail
GET /reports/getSharePointSiteUsageFileCounts

API Reference

GET /api/reports/sharepoint/storage — Get storage analysis
GET /api/reports/sharepoint/storage/sites-at-risk — Get sites approaching quota
GET /api/reports/sharepoint/inactive — Get inactive sites list
POST /api/reports/sharepoint/storage/export — Export report data