turbot/alicloud_insights

Query: vpc_dhcp_options_sets_for_vpc

Usage

powerpipe query alicloud_insights.query.vpc_dhcp_options_sets_for_vpc

SQL

with vpcs as (
select
jsonb_array_elements(associate_vpcs) ->> 'VpcId' as vpc_id
from
alicloud_vpc_dhcp_options_set
)
select
d.dhcp_options_set_id
from
alicloud_vpc_dhcp_options_set as d,
vpcs as v
where
v.vpc_id = $1;