turbot/aws_insights

Query: vpc_no_subnet_count

Usage

powerpipe query aws_insights.query.vpc_no_subnet_count

Steampipe Tables

SQL

select
count(*) as value,
'VPCs Without Subnets' as label,
case when count(*) = 0 then 'ok' else 'alert' end as type
from
aws_vpc as vpc
left join aws_vpc_subnet as s on vpc.vpc_id = s.vpc_id
where
s.subnet_id is null;

Dashboards

The query is used in the dashboards: