turbot/azure_insights

Query: network_virtual_networks_for_network_subnet

Usage

powerpipe query azure_insights.query.network_virtual_networks_for_network_subnet

SQL

select
lower(vn.id) as virtual_network_id
from
azure_subnet as s
left join azure_virtual_network as vn on vn.name = s.virtual_network_name
where
lower(s.subscription_id) = lower(vn.subscription_id)
and lower(s.resource_group) = lower(vn.resource_group)
and lower(s.id) = $1;