turbot/steampipe-mod-azure-insights

Dashboard: Azure Network Security Group Dashboard

This dashboard answers the following questions:

  • How many network security groups are in each subscription, resource group and region?
  • How many network security groups are not associated?
  • How many network security groups do not have flow logs configured?
  • How many network security groups have unrestricted ingress and egress?
This dashboard contains 5 cards.

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 Security Group Dashboard dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select
provisioning_state as "Provisioning State",
count(*) as "Network Security Groups"
from
azure_network_security_group
group by
provisioning_state
order by
provisioning_state;

Tags