OneDrive Storage Reports

Analyze OneDrive storage consumption across your managed tenants. Monitor quota utilization, identify large files and inactive accounts, and optimize storage costs. OpsPilot365 provides aggregated storage insights with drill-down capabilities for individual users and tenants.

Note: OneDrive storage is included with Microsoft 365 licenses. Default allocation is 1 TB per user, expandable to 5 TB for organizations with 5+ licenses. Additional storage beyond 5 TB can be requested from Microsoft. SharePoint tenant storage pools are separate from OneDrive allocations.

Storage Overview Dashboard

The storage dashboard provides a high-level view of OneDrive consumption across all managed tenants with trend analysis and capacity planning metrics.

Storage Trend (Last 12 Months)

Storage usage shows steady growth month over month (J: 65%, F: 68%, M: 72%, A: 75%, M: 78%, J: 82%, J: 85%, A: 88%, S: 90%, O: 93%, N: 95%, D: 100% relative scale).

Per-Tenant Analysis

View storage consumption broken down by tenant. Identify tenants approaching quota limits or with unusual growth patterns requiring attention.

User Storage Details

Drill down to individual user storage consumption. Identify users with high storage usage, sync issues, or inactive accounts consuming quota.

Key Indicators

User Details

File Analysis

Analyze file types and sizes across OneDrive storage. Identify large files, duplicate content, and file type distributions to optimize storage utilization.

Storage by File Type

Large Files (>1 GB)

Sync Status Monitoring

Monitor OneDrive sync client status across managed devices. Identify users with sync issues, pending uploads, or outdated clients that may impact data protection.

Common Sync Issues

Sharing Analysis

Review OneDrive sharing activity and identify potential security concerns. Monitor external sharing, anonymous links, and sharing with guests.

Sharing Summary

External Sharing by Domain

Retention & Deleted Files

Monitor recycle bin contents and retention policy compliance. OneDrive retains deleted files for 93 days by default, consuming storage quota.

Note: Clearing recycle bins and trimming version history could recover approximately 4.6 TB of storage across all tenants. Consider implementing automatic recycle bin cleanup policies for inactive accounts and limiting version history retention.

Report Export & Scheduling

Export storage reports for billing, compliance, or capacity planning. Schedule automated reports to be delivered via email or saved to SharePoint.

Export Formats

• Excel (.xlsx) — Full data with charts
• CSV — Raw data for analysis
• PDF — Executive summary format

Scheduled Reports

Best Practices

Storage Optimization

• Set up alerts for users approaching quota
• Review and archive inactive user data
• Implement file type restrictions for large files
• Enable storage sense for automatic cleanup
• Regular recycle bin purge for departed users

Monitoring & Compliance

• Schedule weekly storage reports
• Track external sharing for sensitive data
• Monitor sync status for backup coverage
• Review version history settings by tenant
• Document storage allocations for billing

API Reference

# Get OneDrive usage report
GET /reports/getOneDriveUsageAccountDetail(period='D30')

# Get user's OneDrive storage quota
GET /users/{user-id}/drive?$select=quota

# OpsPilot365 API - Cross-tenant storage report
GET /api/reports/onedrive/storage
{
  "tenantIds": ["tenant-1", "tenant-2"],
  "period": "last30days",
  "includeInactive": true,
  "format": "json"
}