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

2,456

Total Sites

Across all tenants

45.2 TB

Storage Used

12% of allocated

1.8M

Files

Total documents

234K

Page Views

Last 30 days

Site Activity Analysis

Site TypeCountActive (30d)StorageFiles
Team Sites1,234892 (72%)28.4 TB1.2M
Communication Sites456398 (87%)8.2 TB340K
Hub Sites2828 (100%)1.2 TB45K
Personal (OneDrive)738456 (62%)7.4 TB215K

Storage Analysis

Storage by Site Type

Team Sites28.4 TB (63%)
Communication Sites8.2 TB (18%)
OneDrive7.4 TB (16%)
Other1.2 TB (3%)

Sites Approaching Quota

Marketing Assets98% used
Engineering Docs89% used
Legal Archive85% used
HR Records78% used

External Sharing Analysis

1,234

External Shares

Total active

89

Anonymous Links

No auth required

456

Guest Users

Active guests

Top External Domains

partner-company.com234 files shared
vendor.com156 files shared
consultant.com89 files shared

Inactive Sites

Sites with no activity in the specified period may be candidates for archival or deletion:

Inactivity PeriodSite CountStorage UsedRecommendation
90-180 days1562.3 TBReview
180-365 days891.8 TBArchive candidate
>365 days450.9 TBDelete 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/getSharePointSiteUsageDetail

GET /reports/getSharePointSiteUsageSiteCounts

GET /reports/getSharePointSiteUsageStorage

GET /reports/getSharePointSiteUsageFileCounts

GET /reports/getSharePointActivityUserDetail

API Reference

GET /api/reports/sharepoint/sites

Get site usage summary

GET /api/reports/sharepoint/storage

Get storage analysis

GET /api/reports/sharepoint/external-sharing

Get external sharing report

GET /api/reports/sharepoint/inactive

Get inactive sites list

POST /api/reports/sharepoint/export

Export SharePoint report