turbot/steampipe-mod-azure-insights

Query: network_virtual_network_inventory_table

Usage

powerpipe query azure_insights.query.network_virtual_network_inventory_table

SQL

select
v.name as "Name",
v.address_prefixes as "Address Prefixes",
v.enable_ddos_protection as "Enable DDoS Protection",
v.enable_vm_protection as "Enable VM Protection",
v.provisioning_state as "Provisioning State",
v.resource_guid as "Resource GUID",
v.subnets as "Subnets",
v.network_peerings as "Network Peerings",
v.tags as "Tags",
v.id as "ID",
sub.title as "Subscription",
v.subscription_id as "Subscription ID",
v.resource_group as "Resource Group",
v.region as "Region"
from
azure_virtual_network as v,
azure_subscription as sub
where
v.subscription_id = sub.subscription_id
order by
v.name;

Dashboards

The query is used in the dashboards: