OneDrive Overview
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 or more 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.
Key Metrics
| Metric | Description | Example |
|---|---|---|
| Total Storage Used | Aggregate storage consumption across all tenants | 24.7 TB |
| Total Storage Allocated | Sum of all user quotas | 156 TB |
| Average Usage | Mean storage per user | 158 GB |
| Utilization Rate | Percentage of allocated storage in use | 15.8% |
Storage Trend
The dashboard displays a 12-month storage trend chart showing growth patterns over time. Use this to forecast capacity needs and identify unusual growth spikes.
Per-Tenant Analysis
View storage consumption broken down by tenant. Identify tenants approaching quota limits or with unusual growth patterns requiring attention.
| Tenant | Users | Storage Used | Allocated | Utilization | Status |
|---|---|---|---|---|---|
| Contoso Ltd | 45 | 8.2 TB | 45 TB | 18% | Healthy |
| Fabrikam Inc | 78 | 12.5 TB | 78 TB | 16% | Healthy |
| Northwind Traders | 33 | 4.0 TB | 5 TB | 80% | Warning |
User Storage Details
Drill down to individual user storage consumption. Identify users with high storage usage, sync issues, or inactive accounts consuming quota.
Alert Categories
- High Usage Users — Users exceeding 90% of their storage quota
- Inactive Accounts — No sync activity in 90+ days while still consuming storage
- Rapid Growth — Users with over 50% storage growth in the last 30 days
Example User Report
| User | Tenant | Storage Used | Quota | File Count | Last Sync |
|---|---|---|---|---|---|
john.doe@contoso.com | Contoso Ltd | 892 GB | 1 TB | 12,456 | 2 hours ago |
jane.smith@fabrikam.com | Fabrikam Inc | 456 GB | 1 TB | 8,234 | 1 day ago |
former.emp@northwind.com | Northwind Traders | 234 GB | 1 TB | 4,567 | 124 days ago |
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
| File Type | Storage | Percentage |
|---|---|---|
Videos (.mp4, .mov, .avi) | 8.2 TB | 33% |
Images (.jpg, .png, .gif) | 5.4 TB | 22% |
Documents (.docx, .pdf, .xlsx) | 4.9 TB | 20% |
Archives (.zip, .rar, .7z) | 3.7 TB | 15% |
| Other | 2.5 TB | 10% |
Large Files (over 1 GB)
| File | User | Size |
|---|---|---|
project_backup.zip | john.doe@contoso.com | 4.2 GB |
training_video.mp4 | jane.smith@fabrikam.com | 3.8 GB |
vm_image.vhdx | admin@northwind.com | 2.9 GB |
database_export.bak | it@contoso.com | 2.1 GB |
Retention and Deleted Files
OneDrive retains deleted files for 93 days by default, consuming storage quota.
| Metric | Value |
|---|---|
| Recycle Bin Storage | 1.2 TB across all tenants |
| Files in Recycle Bin | 34,567 pending permanent deletion |
| Version History Storage | 3.4 TB in previous file versions |
Warning: 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 and Scheduling
Export storage reports for billing, compliance, or capacity planning. Schedule automated reports 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
- Weekly Storage Summary
- Monthly Billing Report
- Quarterly Capacity Planning
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 and 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"
}GET /api/onedrive/overview— Get OneDrive overviewGET /api/onedrive/usage— Get usage statistics