turbot/alicloud_insights

Query: vpc_dhcp_options

Usage

powerpipe query alicloud_insights.query.vpc_dhcp_options

SQL

select
distinct dhcp_options_set_id as "DHCP Options Set ID",
name as "Name",
status as "Status",
domain_name as "Domain Name",
domain_name_servers as "Domain Name Servers",
boot_file_name as "Boot File Name",
tftp_server_name as "TFTP Server Name"
from
alicloud_vpc_dhcp_options_set,
jsonb_array_elements(associate_vpcs) as v
where
v ->> 'VpcId' = $1
order by
dhcp_options_set_id;

Dashboards

The query is used in the dashboards: