Table: alicloud_vpc_eip - Query Alibaba Cloud Elastic IP Addresses (EIPs) using SQL

Alibaba Cloud Elastic IP Addresses (EIPs) provide public IP addressing that can be dynamically associated with ECS instances, NAT gateways, or other cloud resources. EIPs support flexible networking and high availability for internet-facing applications.

Table Usage Guide

The alicloud_vpc_eip table allows network engineers and cloud administrators to query detailed information about Elastic IP addresses in Alibaba Cloud. Use this table to retrieve data such as EIP address, allocation ID, status, associated instance or resource, bandwidth settings, internet charge type, and creation time. This information is essential for tracking public IP usage, optimizing bandwidth allocation, and managing cost and connectivity for cloud-based services.

Examples

Basic info

Explore the status and regional distribution of Elastic IP addresses in your Alibaba Cloud Virtual Private Cloud (VPC) to better manage and optimize your network resources.

select
  name,
  allocation_id,
  arn,
  description,
  ip_address,
  status,
  region
from
  alicloud_vpc_eip;

select
  name,
  allocation_id,
  arn,
  description,
  ip_address,
  status,
  region
from
  alicloud_vpc_eip;

Get the info of instance bound to eip

Discover the segments that are linked to a specific Elastic IP in order to understand its allocation, the type of instance it's attached to, and its regional location. This is useful for managing resources and bandwidth within your network infrastructure.

select
  name,
  allocation_id,
  instance_type,
  instance_id,
  instance_region_id,
  bandwidth
from
  alicloud_vpc_eip;

select
  name,
  allocation_id,
  instance_type,
  instance_id,
  instance_region_id,
  bandwidth
from
  alicloud_vpc_eip;

List all the available eips

Determine the areas in which Elastic IP addresses are available for use. This is useful for identifying potential resources in your Alicloud Virtual Private Cloud that are not currently being utilized.

select
  name,
  allocation_id,
  instance_type,
  status
from
  alicloud_vpc_eip
where
  status = 'Available';

select
  name,
  allocation_id,
  instance_type,
  status
from
  alicloud_vpc_eip
where
  status = 'Available';

Get the eips where hd monitoring is off

Identify instances where HD monitoring is turned off for Elastic IP addresses within your Alicloud Virtual Private Cloud. This can be crucial for optimizing your network performance and security measures.

select
  name,
  allocation_id,
  hd_monitor_status
from
  alicloud_vpc_eip
where
  hd_monitor_status = 'OFF';

select
  name,
  allocation_id,
  hd_monitor_status
from
  alicloud_vpc_eip
where
  hd_monitor_status = 'OFF';

Query examples

vpc_eips_for_ecs_instance

Schema for alicloud_vpc_eip

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.
allocation_id	text	=	The unique ID of the EIP.
allocation_time	timestamp with time zone		The time when the EIP was created.
arn	text		The Alibaba Cloud Resource Name (ARN) of the EIP.
available_regions	jsonb		The ID of the region to which the EIP belongs.
bandwidth	text		The peak bandwidth of the EIP. Unit: Mbit/s.
bandwidth_package_bandwidth	text		The maximum bandwidth of the EIP in Mbit/s.
bandwidth_package_type	text		The bandwidth value of the EIP Bandwidth Plan to which the EIP is added.
charge_type	text		The billing method of the EIP
description	text		The description of the EIP.
expired_time	timestamp with time zone		The expiration time of the EIP.
has_reservation_data	boolean		Indicates whether renewal data is included.
hd_monitor_status	text		Indicates whether fine-grained monitoring is enabled for the EIP.
instance_id	text		The ID of the instance to which the EIP is bound.
instance_region_id	text		The region ID of the bound resource.
instance_type	text		The type of the instance to which the EIP is bound.
internet_charge_type	text		The metering method of the EIP can be one of PayByBandwidth or PayByTraffic.
ip_address	inet		The IP address of the EIP.
isp	text		The Internet service provider.
mode	text		The type of the instance to which you want to bind the EIP.
name	text		The name of the EIP.
netmode	text		The network type of the EIP.
operation_locks_reason	jsonb		The reason why the EIP is locked. Valid values: financial security.
private_ip_address	boolean
region	text		The Alicloud region in which the resource is located.
resource_group_id	text		The ID of the resource group.
second_limited	boolean		Indicates whether level-2 traffic throttling is configured.
segment_instance_id	text		The ID of the instance with which the contiguous EIP is associated.
service_managed	bigint
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of the EIP.
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_eip