Forum Discussion
Seyed_Mowlana
Microsoft
Feb 15, 2026SharePoint Reporting using PnP PowerShell through Azure Automation
This article explains how to configure an Azure Automation runbook to execute PnP PowerShell and retrieve SharePoint site collection data across a Microsoft 365 tenant. This method is especially usef...
DmytroV
May 28, 2026Occasional Reader
Hello Seyed.
Brilliant guide, thank you!
Would you be able to advise why it doesn't enumerate all ODFB sites in our tenancy, please?
It works with:
$sites=Get-pnptenantSite -IncludeonedriveSites -Filter "Url -like '-my.sharepoint.com/personal/b'"
And it fails with:
$sites=Get-pnptenantSite -IncludeonedriveSites -Filter "Url -like '-my.sharepoint.com/personal/'"
We only got 70 000 ODFB sites....