Dashboard: Azure Virtual Network Inventory Report

This report answers the following questions:

How many virtual networks are there across my subscriptions?
What address spaces are allocated to each VNet?
Which VNets have DDoS protection enabled?
Which VNets have VM protection enabled?
What DNS servers are configured?
What subnets are configured in each VNet?
Which VNets have peering connections?
How are virtual networks distributed across subscriptions, resource groups, and regions?

The inventory report includes:

Total count of virtual networks
Detailed list of all VNets with:
- Network name and address space
- Protection features (DDoS, VM)
- DNS configuration
- Subnet configuration
- Peering connections
- Resource organization (subscription, resource group, region)
- Associated tags

This dashboard contains 1 card and 1 table.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-azure-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select Azure Virtual Network Inventory Report dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run azure_insights.dashboard.network_virtual_network_inventory_report --share

Queries

This dashboard uses the the following queries:

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;