Table: alicloud_vpc_dhcp_options_set - Query Alibaba Cloud VPC DHCP Options Sets using SQL

Alibaba Cloud Virtual Private Cloud (VPC) enables the creation of isolated network environments. DHCP options sets allow you to define custom configurations such as domain name servers and domain names that are automatically assigned to ECS instances within a VPC.

Table Usage Guide

The alicloud_vpc_dhcp_options_set table enables network engineers and cloud administrators to query detailed information about DHCP options sets configured in Alibaba Cloud VPCs. Use this table to retrieve values such as DHCP options set ID, domain name servers, domain name, lease time, and description. This information is helpful for managing network behavior, standardizing instance configuration, and enforcing internal DNS policies across your cloud environment.

Examples

Basic info

Explore the status and associated count of your Virtual Private Cloud (VPC) configurations with this query. It helps in understanding the deployment of your VPC resources across different regions and accounts, providing insights for better resource management and planning.

select
  name,
  dhcp_options_set_id,
  associate_vpc_count,
  status,
  description,
  domain_name,
  region,
  account_id
from
  alicloud_vpc_dhcp_options_set;

select
  name,
  dhcp_options_set_id,
  associate_vpc_count,
  status,
  description,
  domain_name,
  region,
  account_id
from
  alicloud_vpc_dhcp_options_set;

List VPCs that are associated with DHCP options set

Identify the VPCs that are linked with specific DHCP options sets. This is useful in managing network configurations and ensuring proper communication between devices within your virtual private cloud.

select
  name,
  dhcp_options_set_id,
  vpc ->> "VpcId" as vpc_id
from
  alicloud_vpc_dhcp_options_set,
  jsonb_array_elements(associate_vpcs) as vpc;

select
  name,
  dhcp_options_set_id,
  json_extract(vpc.value, '$.VpcId') as vpc_id
from
  alicloud_vpc_dhcp_options_set,
  json_each(associate_vpcs) as vpc;

Count the number of VPCs associated with DHCP options set

Determine the quantity of virtual private clouds (VPCs) linked with a Dynamic Host Configuration Protocol (DHCP) options set. This can be useful when assessing the extent of network configurations within your system.

select
  name,
  dhcp_options_set_id,
  associate_vpc_count
from
  alicloud_vpc_dhcp_options_set;

select
  name,
  dhcp_options_set_id,
  associate_vpc_count
from
  alicloud_vpc_dhcp_options_set;

List DHCP option sets that are in use

Identify the DHCP option sets that are currently in use. This can help assess network settings and ensure they are configured correctly.

select
  name,
  nat_gateway_id,
  status
from
  alicloud_vpc_dhcp_options_set
where
  status = 'InUse';

select
  name,
  nat_gateway_id,
  status
from
  alicloud_vpc_dhcp_options_set
where
  status = 'InUse';

Query examples

vpc_dhcp_options_sets_for_vpc

Schema for alicloud_vpc_dhcp_options_set

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The Alicloud Account ID in which the resource is located.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
associate_vpc_count	bigint		The number of VPCs associated with DHCP option set.
associate_vpcs	jsonb		The information of the VPC network that is associated with the DHCP options set.
boot_file_name	text		The boot file name of DHCP option set.
description	text		The description for the DHCP option set.
dhcp_options_set_id	text	=	The ID of the DHCP option set.
domain_name	text	=	The root domain.
domain_name_servers	text		The IP addresses of your DNS servers.
name	text	=	The name of the DHCP option set.
owner_id	text		The ID of the account to which the DHCP options set belongs.
region	text		The Alicloud region in which the resource is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of the DHCP option set.
tftp_server_name	text		The tftp server name of the DHCP option set.
title	text		Title of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- alicloud

You can pass the configuration to the command with the --config argument:

steampipe_export_alicloud --config '<your_config>' alicloud_vpc_dhcp_options_set