turbot/alicloud_insights

Query: vpc_gateways_detail

Usage

powerpipe query alicloud_insights.query.vpc_gateways_detail

SQL

select
vpn_gateway_id as "ID",
name as "Name",
'alicloud_vpc_vpn_gateway' as "Type",
status as "Status"
from
alicloud_vpc_vpn_gateway
where
vpc_id = $1
union all
select
nat_gateway_id as "ID",
name as "Name",
'alicloud_vpc_nat_gateway' as "Type",
status as "Status"
from
alicloud_vpc_nat_gateway
where
vpc_id = $1;

Dashboards

The query is used in the dashboards: