turbot/azure_insights

Query: network_subnet_input

Usage

powerpipe query azure_insights.query.network_subnet_input

SQL

select
g.title as label,
lower(g.id) as value,
json_build_object(
'subscription', s.display_name,
'virtual_network_name', g.virtual_network_name,
'resource_group', g.resource_group
) as tags
from
azure_subnet as g,
azure_subscription as s
where
lower(g.subscription_id) = lower(s.subscription_id)
order by
g.title;