turbot/aws_insights

Query: vpc_default_security_group_status

Usage

powerpipe query aws_insights.query.vpc_default_security_group_status

Steampipe Tables

SQL

with default_sg as (
select
group_id,
case
when group_name = 'default' then true
else false
end as is_default
from
aws_vpc_security_group
)
select
case
when is_default then 'default'
else 'non-default'
end as default_status,
count(*)
from
default_sg
group by
is_default;

Dashboards

The query is used in the dashboards: