turbot/aws_insights

Query: vpc_security_group_by_vpc

Usage

powerpipe query aws_insights.query.vpc_security_group_by_vpc

Steampipe Tables

SQL

select
vpc_id as "VPC",
count(*) as "security_groups"
from
aws_vpc_security_group
group by
vpc_id
order by
vpc_id;

Dashboards

The query is used in the dashboards: