Resource Graph Explorer - KQL queries for Azure APP services - get properties

Question

Hi,

I am trying to get a list of all the web apps and their .net version

This is the query I've written, but not getting anywhere with it -

resources
| where ['type'] contains "Microsoft.Web/sites" and kind == "app" 
| project netFrameworkVersion = (properties).config.netFrameworkVersion


resources
| where type =~ 'Microsoft.Web/sites'
| join kind = inner (appserviceresources) on name
| project properties.netFrameworkVersion

Answer 1

Hi ,

appserviceresources is the resource type you should use for this need in Azure Resource Graph Explorer. For more details on supported table resources check here : https://learn.microsoft.com/en-us/azure/governance/resource-graph/reference/supported-tables-resources.

You could try below query to fetch all web apps on a specific .NET framework version

appserviceresources
| where type == "microsoft.web/sites/config"
| extend dotNetVersion = tostring(properties.NetFrameworkVersion)
| where dotNetVersion == "v6.0" //remove this condition to list all webapps
| project SiteName = name, DotNetVersion = dotNetVersion

Please 'Accept as answer' if it helped so that it can help others in the community looking for help on similar topics.