OneDrive Reports

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

Available Reports

Account Activity

Per-user OneDrive activity: files viewed, edited, synced, and shared. Identify active users and adoption patterns.

Source: GET /reports/getOneDriveActivityUserDetail

Storage Usage

Storage consumption per user: used vs. allocated quota, growth trends, users approaching limits.

Source: GET /reports/getOneDriveUsageAccountDetail

File Statistics

File counts across OneDrive accounts: total files, active files, file types distribution.

Source: GET /reports/getOneDriveUsageFileCounts

Sync Status

OneDrive sync client status: devices syncing, sync errors, clients needing updates.

Sharing Activity

Files shared from OneDrive: internal vs. external shares, sharing links created, guest access.

Key Metrics

12,456

Active Users

Last 30 days

23.8 TB

Storage Used

Total consumption

4.2M

Files Stored

All accounts

89%

Sync Rate

Active sync clients

Usage Analysis

User Activity Distribution

45%

Power Users

Daily activity

32%

Regular Users

Weekly activity

15%

Light Users

Monthly activity

8%

Inactive

No activity 30+ days

Activity Types (Last 30 Days)

ActivityCountUnique UsersTrend
Files Viewed1,234,56710,234↑ 12%
Files Edited456,7898,456↑ 8%
Files Synced2,345,6789,876↑ 5%
Files Shared89,0125,432↓ 3%

Storage Analysis

Storage Distribution

<1 GB45% of users
1-5 GB32% of users
5-25 GB18% of users
>25 GB5% of users

Users Near Quota Limit

john.doe@company.com98.5 GB / 100 GB
jane.smith@company.com92.1 GB / 100 GB
bob.jones@company.com87.3 GB / 100 GB
alice.wilson@company.com79.8 GB / 100 GB

Sync Client Status

9,234

Healthy Sync

Syncing normally

456

Sync Paused

User paused or metered

89

Sync Errors

Needs attention

Common Sync Issues

File name not allowed34 occurrences
File too large23 occurrences
Outdated client18 occurrences
Network connectivity14 occurrences

Sharing Analysis

12,345

Internal Shares

3,456

External Shares

234

Anonymous Links

89

Expiring Links

Security Note: 234 anonymous sharing links detected. Consider reviewing these for potential data exposure.

Inactive Accounts

OneDrive accounts with no activity may indicate license optimization opportunities:

Inactivity PeriodAccountsStorage UsedRecommendation
30-90 days2341.2 TBMonitor
90-180 days1560.8 TBContact user
>180 days890.4 TBReview license

Report Filters

  • Date Range — Last 7, 30, 90, 180 days or custom
  • Tenant — All tenants, specific tenant, or groups
  • User — All users, departments, or individuals
  • Activity Level — Active, Low activity, Inactive
  • Storage Usage — All, over threshold, near quota

Graph API Data Sources

GET /reports/getOneDriveActivityUserDetail

GET /reports/getOneDriveActivityFileCounts

GET /reports/getOneDriveUsageAccountDetail

GET /reports/getOneDriveUsageFileCounts

GET /reports/getOneDriveUsageStorage

API Reference

GET /api/reports/onedrive/activity

Get user activity summary

GET /api/reports/onedrive/storage

Get storage usage report

GET /api/reports/onedrive/sync

Get sync client status

GET /api/reports/onedrive/sharing

Get sharing activity report

POST /api/reports/onedrive/export

Export OneDrive report