turbot/alicloud
steampipe plugin install alicloud

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';

Schema for alicloud_vpc_dhcp_options_set

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The Alicloud Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
associate_vpc_countbigintThe number of VPCs associated with DHCP option set.
associate_vpcsjsonbThe information of the VPC network that is associated with the DHCP options set.
boot_file_nametextThe boot file name of DHCP option set.
descriptiontextThe description for the DHCP option set.
dhcp_options_set_idtext=The ID of the DHCP option set.
domain_nametext=The root domain.
domain_name_serverstextThe IP addresses of your DNS servers.
nametext=The name of the DHCP option set.
owner_idtextThe ID of the account to which the DHCP options set belongs.
regiontextThe Alicloud region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statustextThe status of the DHCP option set.
tftp_server_nametextThe tftp server name of the DHCP option set.
titletextTitle 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