Table: alicloud_vpc_dhcp_options_set

Dynamic Host Configuration Protocol (DHCP) is a network management protocol. DHCP provides a standard for passing configuration information to servers in a TCP/IP network.

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