turbot/azure_insights

Query: app_service_web_apps_for_network_subnet

Usage

powerpipe query azure_insights.query.app_service_web_apps_for_network_subnet

SQL

select
lower(id) as web_app_id
from
azure_app_service_web_app
where
lower(vnet_connection -> 'properties' ->> 'vnetResourceId') = $1