turbot/steampipe-mod-aws-insights

Dashboard: AWS VPC Security Group Detail

This dashboard answers the following questions for each security group:

  • How is the security group configured?
  • What tags are applied?
  • Which resources is it associated to?
  • What are the ingress and egress rules configured?
This dashboard contains 5 cards, 2 flows, 1 graph, 1 input and 5 tables.

Usage

Install the mod:

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

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select AWS VPC Security Group Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run aws_insights.dashboard.vpc_security_group_detail --share

Queries

This dashboard uses the the following queries:
select
'Attached ENIs' as label,
count(*) as value,
case when count(*) > 0 then 'ok' else 'alert' end as type
from
aws_ec2_network_interface,
jsonb_array_elements(groups) as sg
where
sg ->> 'GroupId' = $1;

Tags