turbot/steampipe-mod-aws-insights

Query: vpc_inventory_table

Usage

powerpipe query aws_insights.query.vpc_inventory_table

Steampipe Tables

SQL

select
v.vpc_id as "VPC ID",
v.cidr_block as "CIDR Block",
v.instance_tenancy as "Instance Tenancy",
v.is_default as "Is Default VPC",
v.state as "State",
v.tags as "Tags",
v.arn as "ARN",
v.account_id as "Account ID",
a.title as "Account",
v.region as "Region"
from
aws_vpc as v
left join aws_account as a on v.account_id = a.account_id
order by
v.vpc_id;

Dashboards

The query is used in the dashboards: