Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
Thank you for confirming offline that the KQL queries below were helpful in retrieving the list of App Service apps within the subscription.
For Linux-based apps (most common for Node.js):
resources
| where type =~ "microsoft.web/sites"
| extend linuxFx = tostring(properties.siteConfig.linuxFxVersion)
| where linuxFx == "NODE|20-lts"
| project resourceGroup, name, linuxFx
For Windows-based apps:
resources
| where type =~ "microsoft.web/sites"
| where kind !contains "linux"
| mv-expand appSetting = properties.siteConfig.appSettings
| where appSetting.name == "WEBSITE_NODE_DEFAULT_VERSION"
| where tostring(appSetting.value) startswith "~20" or tostring(appSetting.value) contains "20"
| project resourceGroup, name, nodeVersion = tostring(appSetting.value), location
reference:
https://learn.microsoft.com/en-us/azure/app-service/language-support-policy?tabs=windows
Please do not forget to click "Accept the answer” and Yes, this can be beneficial to other community members.
If you have any other questions, let me know in the "comments" and I would be happy to help you