SharePoint Reports
Comprehensive reporting on SharePoint Online usage, storage, sharing activity, and site analytics across your managed tenants. Track adoption, identify inactive sites, and monitor external sharing patterns.
Available Reports
Site Usage
Activity across SharePoint sites: page views, unique visitors, files viewed, files synced. Identify most active and least used sites.
Source: GET /reports/getSharePointSiteUsageDetail
Storage Usage
Storage consumption by site: allocated vs. used, growth trends, sites approaching quota limits. Plan capacity and identify cleanup opportunities.
Source: GET /reports/getSharePointSiteUsageStorage
File Activity
File operations: views, edits, downloads, shares. Track document collaboration patterns and identify highly active content.
Source: GET /reports/getSharePointActivityUserDetail
External Sharing
Content shared with external users: anonymous links, guest access, sharing by domain. Monitor for data exposure risks.
Site Creation
New sites created over time: who created them, templates used, team vs. communication sites. Track site sprawl.
Key Metrics
| Metric | Value | Detail |
|---|---|---|
| Total Sites | 2,456 | Across all tenants |
| Storage Used | 45.2 TB | 12% of allocated |
| Files | 1.8M | Total documents |
| Page Views | 234K | Last 30 days |
Site Activity Analysis
| Site Type | Count | Active (30d) | Storage | Files |
|---|---|---|---|---|
| Team Sites | 1,234 | 892 (72%) | 28.4 TB | 1.2M |
| Communication Sites | 456 | 398 (87%) | 8.2 TB | 340K |
| Hub Sites | 28 | 28 (100%) | 1.2 TB | 45K |
| Personal (OneDrive) | 738 | 456 (62%) | 7.4 TB | 215K |
Storage Analysis
Storage by Site Type
| Site Type | Storage | Percentage |
|---|---|---|
| Team Sites | 28.4 TB | 63% |
| Communication Sites | 8.2 TB | 18% |
| OneDrive | 7.4 TB | 16% |
| Other | 1.2 TB | 3% |
Sites Approaching Quota
| Site | Usage |
|---|---|
| Marketing Assets | 98% used |
| Engineering Docs | 89% used |
| Legal Archive | 85% used |
| HR Records | 78% used |
External Sharing Analysis
| Metric | Count | Detail |
|---|---|---|
| External Shares | 1,234 | Total active |
| Anonymous Links | 89 | No auth required |
| Guest Users | 456 | Active guests |
Top External Domains
| Domain | Files Shared |
|---|---|
| partner-company.com | 234 files shared |
| vendor.com | 156 files shared |
| consultant.com | 89 files shared |
Inactive Sites
Sites with no activity in the specified period may be candidates for archival or deletion:
| Inactivity Period | Site Count | Storage Used | Recommendation |
|---|---|---|---|
| 90-180 days | 156 | 2.3 TB | Review |
| 180-365 days | 89 | 1.8 TB | Archive candidate |
| >365 days | 45 | 0.9 TB | Delete candidate |
Report Filters
- Date Range — Last 7, 30, 90, 180 days or custom
- Tenant — All tenants, specific tenant, or groups
- Site Type — Team, Communication, Hub, or all
- Activity Level — Active, Low activity, Inactive
- Storage Threshold — Above/below certain usage
Graph API Data Sources
GET /reports/getSharePointSiteUsageDetailGET /reports/getSharePointSiteUsageSiteCountsGET /reports/getSharePointSiteUsageStorageGET /reports/getSharePointSiteUsageFileCountsGET /reports/getSharePointActivityUserDetail
API Reference
GET /api/reports/sharepoint/sites— Get site usage summaryGET /api/reports/sharepoint/storage— Get storage analysisGET /api/reports/sharepoint/external-sharing— Get external sharing reportGET /api/reports/sharepoint/inactive— Get inactive sites listPOST /api/reports/sharepoint/export— Export SharePoint report