turbot/azure_insights

Query: network_application_gateways_for_network_subnet

Usage

powerpipe query azure_insights.query.network_application_gateways_for_network_subnet

SQL

select
lower(id) as application_gateway_id
from
azure_application_gateway,
jsonb_array_elements(gateway_ip_configurations) as c
where
lower(c -> 'properties' -> 'subnet' ->> 'id') = $1;