turbot/azure_insights

Query: network_firewalls_for_network_subnet

Usage

powerpipe query azure_insights.query.network_firewalls_for_network_subnet

Steampipe Tables

SQL

select
lower(f.id) as network_firewall_id
from
azure_firewall as f,
jsonb_array_elements(ip_configurations) as c
where
lower(c -> 'subnet' ->> 'id') = $1