turbot/azure_insights

Query: network_security_groups_for_network_subnet

Usage

powerpipe query azure_insights.query.network_security_groups_for_network_subnet

SQL

select
lower(nsg.id) as nsg_id
from
azure_network_security_group as nsg,
jsonb_array_elements(nsg.subnets) as sub
where
lower(sub ->> 'id') = $1