turbot/aws_insights

Query: vpc_peers_for_vpc

Usage

powerpipe query aws_insights.query.vpc_peers_for_vpc

SQL

select
id as "ID",
tags ->> 'Name' as "Name",
status_code as "Status Code",
requester_owner_id as "Request Owner ID",
requester_region as "Requester Region",
requester_vpc_id as "Requester VPC ID",
requester_cidr_block as "Requester CIDR Block",
accepter_owner_id "Accepter Owner ID",
accepter_region "Accepter Region",
accepter_vpc_id "Accepter VPC ID",
accepter_cidr_block as "Accepter CIDR Block"
from
aws_vpc_peering_connection
where
requester_vpc_id = $1
or accepter_vpc_id = $1
order by
id

Dashboards

The query is used in the dashboards: