Azure Active Directory Group Age ReportAzure Active Directory Group DashboardAzure Active Directory Group DetailAzure Active Directory User Age ReportAzure Active Directory User DashboardAzure Active Directory User DetailAzure App Service Web App DashboardAzure App Service Web App DetailAzure App Service Web App Inventory ReportAzure Compute Disk Age ReportAzure Compute Disk DashboardAzure Compute Disk DetailAzure Compute Disk Encryption ReportAzure Compute Disk Inventory ReportAzure Compute Snapshot Age ReportAzure Compute Snapshot DashboardAzure Compute Snapshot DetailAzure Compute Virtual Machine DashboardAzure Compute Virtual Machine DetailAzure Compute Virtual Machine Scale Set DashboardAzure Compute Virtual Machine Scale Set DetailAzure Compute Virtual Machine Scale Set VM DetailAzure Cosmos DB Account Inventory ReportAzure CosmosDB Account DashboardAzure CosmosDB Account DetailAzure CosmosDB Account Encryption ReportAzure CosmosDB Mongo Database DetailAzure Key Vault DashboardAzure Key Vault DetailAzure Key Vault Inventory ReportAzure Key Vault Key Age ReportAzure Key Vault Key DashboardAzure Key Vault Key DetailAzure Kubernetes Cluster DashboardAzure Kubernetes Cluster DetailAzure Kubernetes Cluster Inventory ReportAzure Network Express Route Circuit DashboardAzure Network Express Route Circuit DetailAzure Network Firewall DetailAzure Network Interface DetailAzure Network Load Balancer DetailAzure Network Public IP DetailAzure Network Security Group DashboardAzure Network Security Group DetailAzure Network Security Group Inventory ReportAzure Network Subnet DetailAzure SQL Database Age ReportAzure SQL Database DashboardAzure SQL Database DetailAzure SQL Database Inventory ReportAzure SQL Server DashboardAzure SQL Server DetailAzure SQL Server Encryption ReportAzure SQL Server Inventory ReportAzure Storage Account Age ReportAzure Storage Account DashboardAzure Storage Account DetailAzure Storage Account Inventory ReportAzure Subscription ReportAzure Virtual Machine Inventory ReportAzure Virtual Network DashboardAzure Virtual Network DetailAzure Virtual Network Inventory Report
Dashboard: Azure Network Security Group Inventory Report
This report answers the following questions:
- How many network security groups are there across my subscriptions?
- What is the provisioning state of each NSG?
- How many security rules are configured for each NSG?
- How many default security rules are present?
- Which NSGs are associated with network interfaces?
- Which NSGs are associated with subnets?
- Which NSGs have flow logs enabled?
- How are NSGs distributed across subscriptions, resource groups, and regions?
The inventory report includes:
- Total count of network security groups
- Detailed list of all NSGs with:
- NSG name and provisioning state
- Count of security rules (custom and default)
- Network interface and subnet associations
- Flow log configuration
- Resource organization (subscription, resource group, region)
- Associated tags
This dashboard contains 1 card and 1 table.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-azure-insightsStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select Azure Network Security Group Inventory Report dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run azure_insights.dashboard.network_security_group_inventory_report --shareQueries
This dashboard uses the the following queries:
select count(*) as "Network Security Groups" from azure_network_security_group;