OneDrive Storage Report

Track OneDrive for Business storage consumption, usage patterns, and sharing activity across your organization. Monitor adoption, identify inactive accounts, and manage storage efficiently.

Overview

The OneDrive Storage Report provides detailed visibility into storage consumption per user, growth trends, quota utilization, and sharing patterns. Use this data to optimize storage allocation, identify license optimization opportunities, and monitor for potential data exposure through sharing.

Report Columns

Column	Description
User	Display name and email address
Storage Used	Current OneDrive storage consumption
Storage Quota	Allocated storage quota
Quota Used %	Percentage of quota consumed
File Count	Total number of files stored
Last Activity	Date of most recent OneDrive activity
Sync Status	Healthy, Paused, Error, or Not Syncing
Sharing Activity	Count of files shared internally and externally

Storage Analysis

Storage distribution across users:

Less than 1 GB — Light users with minimal storage
1-5 GB — Average storage consumption
5-25 GB — Above average storage users
Over 25 GB — Heavy storage users approaching quotas

Usage Metrics

Activity	Description
Files Viewed	Documents opened and read
Files Edited	Documents modified
Files Synced	Documents synchronized via OneDrive client
Files Shared	Documents shared with others (internal or external)

Users Near Quota

Warning: Users approaching their storage quota may be unable to sync new files. Monitor users above 80% quota usage and consider increasing quotas or implementing cleanup policies.

Inactive Account Analysis

Identify OneDrive accounts with no activity for license optimization:

Inactivity Period	Recommendation
30-90 days	Monitor
90-180 days	Contact user
Over 180 days	Review license assignment

Filters

Date Range — Last 7, 30, 90, 180 days or custom
Tenant — All tenants, specific tenant, or groups
Activity Level — Active, Low activity, Inactive
Storage Usage — All, over threshold, near quota
User — Filter by specific user or department

Graph API Data Sources

GET /reports/getOneDriveUsageAccountDetail
GET /reports/getOneDriveUsageFileCounts
GET /reports/getOneDriveUsageStorage
GET /reports/getOneDriveActivityUserDetail

API Reference

GET /api/reports/onedrive/storage — Get storage usage report
GET /api/reports/onedrive/activity — Get user activity summary
GET /api/reports/onedrive/sharing — Get sharing activity report
POST /api/reports/onedrive/export — Export OneDrive report