turbot/steampipe-mod-azure-insights

Dashboard: Azure Network Firewall Detail

This dashboard answers the following questions:

  • How is the network firewall configured?
  • What relationships does the network firewall have with other resources?
  • What tags are applied?
This dashboard contains 3 cards, 1 graph, 1 input and 3 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 Network Firewall Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select
c ->> 'privateIPAddress' as "Private IP Address",
c -> 'publicIPAddress' ->> 'id' as "Public IP Address",
c ->> 'provisioningState' as "Provisioning State",
c -> 'subnet' ->> 'id' as "Subnet ID"
from
azure_firewall,
jsonb_array_elements(ip_configurations) as c
where
lower(id) = $1
and subscription_id = split_part($1, '/', 3);

Tags