I stumbled upon 1 App Service Plan in the report shown as having 0 apps. But when checking in the Azure portal, it is running 2 apps. I am looking at the Workbook and the portal using the same account (so shouldn't be an IAM-issue).
This appears to be a common issue when querying App Service Plan properties via Azure Resource Graph or Workbooks—the numberOfSites property often returns 0 because it’s not dynamically updated or exposed in the same way as the portal view.
Why numberOfSites Shows 0
- The numberOfSites property in the App Service Plan resource is not always populated in the ARM metadata.
- It’s a legacy property and may not reflect the current state of apps in the plan.
- The portal calculates the number of apps by querying the Web Apps resource type, not the plan itself.
How to Confirm Which Apps Are in the Plan
Instead of relying on numberOfSites, query the Web Apps (microsoft.web/sites) and filter by serverFarmId (which is the App Service Plan ID).
Is it possible to change the query that reports this count?
I stumbled upon 1 App Service Plan in the report shown as having 0 apps. But when checking in the Azure portal, it is running 2 apps. I am looking at the Workbook and the portal using the same account (so shouldn't be an IAM-issue).
This appears to be a common issue when querying App Service Plan properties via Azure Resource Graph or Workbooks—the numberOfSites property often returns 0 because it’s not dynamically updated or exposed in the same way as the portal view.
Why numberOfSites Shows 0
How to Confirm Which Apps Are in the Plan
Instead of relying on numberOfSites, query the Web Apps (microsoft.web/sites) and filter by serverFarmId (which is the App Service Plan ID).
Is it possible to change the query that reports this count?