List All SharePoint Sites and Their Document Libraries via Microsoft Graph

Collect the list manually from the SharePoint admin center

This approach works for small tenants but does not expose library URLs directly — you must visit each site to capture them.

Step 1 — Open the SharePoint admin center

1. Sign in to https://admin.microsoft.com as a Global Administrator or SharePoint Administrator.
2. In the left nav, expand Admin centers → SharePoint.

Step 2 — Export the site list

1. In the SharePoint admin center, go to Sites → Active sites.
2. Click Export (top-right toolbar) to download a CSV of all active sites. This gives you site name, URL, template, storage, and owner — but NOT library URLs.

Step 3 — Capture document libraries for each site

1. For each site in the exported CSV, click the site URL to open it.
2. In the site's left navigation, note each item listed under Documents or the Site contents page (gear icon → Site contents).
3. Each document library's URL is of the form https://<tenant>.sharepoint.com/sites/<site>/<LibraryName>. Copy these into your spreadsheet.

Recommendation: For anything beyond ~5 sites, skip this manual path and use the API or PowerShell recipes below.

Enumerate sites and drives with Microsoft Graph

Two endpoints do the heavy lifting: list sites, then for each site list its drives.

Step 1 — List all SharePoint sites

GET https://graph.microsoft.com/v1.0/sites?search=&$select=id,displayName,webUrl&$top=999

Note: use search= (empty) rather than search=*; the wildcard form returns HTTP 500 on some tenants.

Sample response:

{
  "value": [
    {
      "id": "contoso.sharepoint.com,6bee9a7d-...,348121bc-...",
      "displayName": "Mark 8 Project Team",
      "webUrl": "https://contoso.sharepoint.com/sites/Mark8ProjectTeam"
    }
  ]
}

Step 2 — List document libraries for each site

GET https://graph.microsoft.com/v1.0/sites/{site-id}/drives?$select=id,name,webUrl,driveType

Sample response:

{
  "value": [
    {
      "id": "b!fZru...",
      "name": "Documents",
      "webUrl": "https://contoso.sharepoint.com/sites/Mark8ProjectTeam/Shared%20Documents",
      "driveType": "documentLibrary"
    }
  ]
}

Step 3 — Handle pagination

If either response contains an @odata.nextLink, follow it until absent. Large tenants will paginate the site list into multiple pages of up to 200–500 items.

Step 4 — Watch for 429 throttling

When fanning out drive lookups across many sites, respect Retry-After headers. A 200ms delay between sequential calls keeps most tenants safely under the limit.

PowerShell inventory script

The downloadable script below uses the Microsoft Graph PowerShell SDK to enumerate sites and drives, then writes a CSV report.

Prerequisites

• Microsoft.Graph PowerShell SDK: Install-Module Microsoft.Graph -Scope CurrentUser
• Sites.Read.All consent granted (delegated or application).

How it works

1. Connects to Graph with the Sites.Read.All scope.
2. Calls Get-MgSite -Search "" and pages through all results.
3. For each site, calls Get-MgSiteDrive to list document libraries.
4. Flattens the data into one row per library and exports to CSV.
5. Includes retry logic for HTTP 429 (throttling) and skips sites that return permission errors.

Run it

.\Get-SharePointSitesAndLibraries.ps1 -OutputPath "C:\Reports\SPInventory.csv"

The script prints a per-site progress line and a final summary (total sites, total libraries, sites with errors).