turbot/steampipe-mod-azure-insights

Dashboard: Azure Virtual Network Detail

This dashboard answers the following questions for each virtual network:

  • How is the virtual network configured?
  • What relationships does the virtual network have with other resources?
  • What tags are applied?
  • What are the address prefixes assigned to?
  • What are the subnets attached to?
  • How the route tables are configured?
  • What are the peering connections associated?
  • How network security groups are configured?
This dashboard contains 3 cards, 2 flows, 1 graph, 1 input and 8 tables.

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 Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select
(trim('"' FROM p::text))::cidr as "Address Prefix",
power(2, 32 - masklen( (trim('"' FROM p::text) ):: cidr)) as "Total IPs"
from
azure_virtual_network,
jsonb_array_elements(address_prefixes) as p
where
lower(id) = $1
and subscription_id = split_part($1, '/', 3);

Tags