OneDrive List

The question it answers: Which OneDrives exist, who owns them, how much storage do they use and do they allow external sharing?

Note

All values come from Get-PnPTenantSite -IncludeOneDriveSites: storage and quota (MB converted to GB), owner, LastContentModifiedDate and SharingCapability (External Sharing = anything but Disabled). File, link, sync and deleted-item counts are not part of that call and are not shown.

At a glance

Where in the app	OneDrives › All OneDrives
Workload	OneDrive
Kind	Table
Data	Read from Microsoft 365 when someone first opens it, then kept for the report cache lifetime (Settings > Data & cache, 1 hour unless changed). It reads through PowerShell (Exchange Online or SharePoint Online), so the first load takes longer than a Graph report.
Licence	No extra licence needed.
Report id (API and MCP)	onedrive.drives.all

Columns

Column	Key	Type
Title	Title	Text
Owner	Owner	Text
Storage Usage (GB)	StorageUsageGb	Text
Storage Quota (GB)	StorageQuotaGb	Text
External Sharing	ExternalSharing	Text
Url	Url	Text
Sharing Capability	SharingCapability	Text
Last Content Modified	LastContentModifiedDate	DateTime

What it needs

Licence: No extra licence needed.

Application permissions on the IntensiveReports app registration (all permissions):

Permission	API	What it allows	Note
Sites.FullControl.All	Office 365 SharePoint Online	Have full control of all site collections	certificate PnP

Data sources it reads

• PowerShell (PnP): Get-PnPTenantSite -IncludeOneDriveSites -Detailed (Url matching my.sharepoint.com)

Through the API and MCP

GET /ir-api/v1/reports/onedrive.drives.all?size=100

An AI assistant reads it with the MCP tool get_report and the id onedrive.drives.all. The client needs the Read grant for OneDrive. See Using the API.