All Document Libraries

The question it answers: Which document libraries exist in the SharePoint sites, and when was each last modified?

Note

Every SharePoint site (OneDrive personal sites skipped) and every drive of type documentLibrary in it. The table does not show which site a library belongs to (the model has no site column), so names such as ‘Documents’ repeat once per site. One call per site: large tenants take a while.

At a glance

Where in the app	SharePoint Online › Document Libraries › All DocumentLibraries
Workload	SharePoint Online
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).
Licence	No extra licence needed.
Report id (API and MCP)	sharepoint.document-libraries.all

Columns

Column	Key	Type
Site	SiteName	Text
Name	Name	Link
ID	ID	Text
Drive Type	DriveType	Text
Last Modified	LastModifiedDateTimeOffset	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.Read.All	Microsoft Graph	Read items in all site collections

Data sources it reads

• GET /v1.0/sites/getAllSites (all pages)
• GET /v1.0/sites/{id}/drives (all pages, per site)

Through the API and MCP

GET /ir-api/v1/reports/sharepoint.document-libraries.all?size=100

An AI assistant reads it with the MCP tool get_report and the id sharepoint.document-libraries.all. The client needs the Read grant for SharePoint Online. See Using the API.