turbot/azure_insights

Query: network_subnets_for_app_service_web

Usage

powerpipe query azure_insights.query.network_subnets_for_app_service_web

SQL

select
lower(id) as subnet_id
from
azure_subnet
where
lower(id) in (
select
lower(vnet_connection -> 'properties' ->> 'vnetResourceId')
from
azure_app_service_web_app
where
lower(id) = $1
);