Web Discover essential FinOps best practices to optimize cost efficiency and governance for your Azure web resources.
On this page
App Service
Query: Web Application Status
This Azure Resource Graph (ARG) query retrieves the status and basic information of web applications within your Azure environment.
Category
Monitoring
Query
Click to view the code
```kql resources | where type =~ 'Microsoft.Web/sites' | project id, WebAppName=name, Type=kind, Status=tostring(properties.state), WebAppLocation=location, AppServicePlan=tostring(properties.serverFarmId), WebAppRG=resourceGroup, SubscriptionId=subscriptionId | order by id asc ```Query: App Service plan details
This Azure Resource Graph (ARG) query retrieves detailed information about Azure App Service Plans within your Azure environment.
Category
Resource management
Query
Click to view the code
```kql resources | where type == "microsoft.web/serverfarms" and sku.tier !~ 'Free' | project planId = tolower(tostring(id)), name, skuname = tostring(sku.name), skutier = tostring(sku.tier), workers = tostring(properties.numberOfWorkers), maxworkers = tostring(properties.maximumNumberOfWorkers), webRG = resourceGroup, Sites = tostring(properties.numberOfSites), SubscriptionId = subscriptionId | join kind=leftouter ( resources | where type =="microsoft.insights/autoscalesettings" | project planId = tolower(tostring(properties.targetResourceUri)), PredictiveAutoscale = properties.predictiveAutoscalePolicy.scaleMode, AutoScaleProfiles = properties.profiles, resourceGroup ) on planId ```🙋♀️ Looking for more?
We’d love to hear about any datasets you’re looking for. Create a new issue with the details that you’d like to see either included in existing or new best practices.
🧰 Related tools
- 📒 Cost optimization workbook – Central hub for cost optimization.