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
| Metric | Value | Detail |
|---|---|---|
| Active Users | 12,456 | Last 30 days |
| Storage Used | 23.8 TB | Total consumption |
| Files Stored | 4.2M | All accounts |
| Sync Rate | 89% | Active sync clients |
Usage Analysis
User Activity Distribution
| Segment | Percentage | Activity Level |
|---|---|---|
| Power Users | 45% | Daily activity |
| Regular Users | 32% | Weekly activity |
| Light Users | 15% | Monthly activity |
| Inactive | 8% | No activity 30+ days |
Activity Types (Last 30 Days)
| Activity | Count | Unique Users | Trend |
|---|---|---|---|
| Files Viewed | 1,234,567 | 10,234 | +12% |
| Files Edited | 456,789 | 8,456 | +8% |
| Files Synced | 2,345,678 | 9,876 | +5% |
| Files Shared | 89,012 | 5,432 | -3% |
Storage Analysis
Storage Distribution
| Usage Range | Percentage of Users |
|---|---|
| Under 1 GB | 45% of users |
| 1-5 GB | 32% of users |
| 5-25 GB | 18% of users |
| Over 25 GB | 5% of users |
Users Near Quota Limit
| User | Usage |
|---|---|
| john.doe@company.com | 98.5 GB / 100 GB |
| jane.smith@company.com | 92.1 GB / 100 GB |
| bob.jones@company.com | 87.3 GB / 100 GB |
| alice.wilson@company.com | 79.8 GB / 100 GB |
Sync Client Status
| Status | Count | Detail |
|---|---|---|
| Healthy Sync | 9,234 | Syncing normally |
| Sync Paused | 456 | User paused or metered |
| Sync Errors | 89 | Needs attention |
Common Sync Issues
| Issue | Occurrences |
|---|---|
| File name not allowed | 34 |
| File too large | 23 |
| Outdated client | 18 |
| Network connectivity | 14 |
Sharing Analysis
| Metric | Count |
|---|---|
| Internal Shares | 12,345 |
| External Shares | 3,456 |
| Anonymous Links | 234 |
| Expiring Links | 89 |
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 Period | Accounts | Storage Used | Recommendation |
|---|---|---|---|
| 30-90 days | 234 | 1.2 TB | Monitor |
| 90-180 days | 156 | 0.8 TB | Contact user |
| >180 days | 89 | 0.4 TB | Review 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/getOneDriveActivityUserDetailGET /reports/getOneDriveActivityFileCountsGET /reports/getOneDriveUsageAccountDetailGET /reports/getOneDriveUsageFileCountsGET /reports/getOneDriveUsageStorage
API Reference
GET /api/reports/onedrive/activity— Get user activity summaryGET /api/reports/onedrive/storage— Get storage usage reportGET /api/reports/onedrive/sync— Get sync client statusGET /api/reports/onedrive/sharing— Get sharing activity reportPOST /api/reports/onedrive/export— Export OneDrive report