turbot/aws_insights

Query: vpc_by_size

Usage

powerpipe query aws_insights.query.vpc_by_size

Steampipe Tables

SQL

with vpc_size as (
select
vpc_id,
cidr_block,
concat(
'/', masklen(cidr_block),
' (', power(2, 32 - masklen(cidr_block :: cidr)), ')'
) as size
from
aws_vpc
)
select
size,
count(*)
from
vpc_size
group by
size;

Dashboards

The query is used in the dashboards: