Table: alicloud_ecs_network_interface

An elastic network interface (ENI) is a virtual network interface controller (NIC) that can be bound to a VPC-type ECS instance. You can use ENIs to deploy high availability clusters and perform low-cost failover and fine-grained network management.

Examples

Basic ENI info

select
  network_interface_id,
  type,
  description,
  status,
  instance_id,
  private_ip_address,
  associated_public_ip_address,
  mac_address
from
  alicloud_ecs_network_interface;

Find all ENIs with private IPs that are in a given subnet (10.66.0.0/16)

select
  network_interface_id,
  type,
  description,
  private_ip_address,
  associated_public_ip_address,
  mac_address
from
  alicloud_ecs_network_interface
where
  private_ip_address << = '10.66.0.0/16';

Count of ENIs by interface type

select
  type,
  count(type) as count
from
  alicloud_ecs_network_interface
group by
  type
order by
  count desc;

Security groups attached to each ENI

select
  network_interface_id as eni,
  sg
from
  alicloud_ecs_network_interface
  cross join jsonb_array_elements(security_group_ids) as sg
order by
  eni;

Find ENIs for a specific instance

select
  network_interface_id as eni,
  instance_id,
  status,
  type,
  description,
  private_ip_address,
  associated_public_ip_address,
  mac_address
from
  alicloud_ecs_network_interface
where
  instance_id = 'i-0xi8u2s0ezl5auigem8t'

Query examples

.inspect alicloud_ecs_network_interface

Alicloud ECS Network Interface.

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
associated_public_ip_address	inet	The public IP address of the instance.
associated_public_ip_allocation_id	text	The allocation ID of the EIP.
attachment	jsonb	Attachments of the ENI
creation_time	timestamp with time zone	The time when the ENI was created.
description	text	The description of the ENI.
instance_id	text	The ID of the instance to which the ENI is bound.
ipv6_sets	jsonb	The IPv6 addresses assigned to the ENI.
mac_address	text	The MAC address of the ENI.
name	text	The name of the ENI.
network_interface_id	text	An unique identifier for the ENI.
owner_id	text	The ID of the account that owns the ENI.
private_ip_address	inet	The private IP address of the ENI.
private_ip_sets	jsonb	The private IP addresses of the ENI.
queue_number	bigint	The number of queues supported by the ENI.
region	text	The Alicloud region in which the resource is located.
resource_group_id	text	The ID of the resource group to which the ENI belongs.
security_group_ids	jsonb	The IDs of the security groups to which the ENI belongs.
service_id	text	The ID of the distributor to which the ENI belongs.
service_managed	boolean	Indicates whether the user is an Alibaba Cloud service or a distributor.
status	text	The status of the ENI.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags attached with the resource.
title	text	Title of the resource.
type	text	The type of the ENI. Valid values: 'Primary' and 'Secondary'
vpc_id	text	The ID of the VPC to which the ENI belongs.
vswitch_id	text	The ID of the VSwitch to which the ENI is connected.
zone_id	text	The zone ID of the ENI.

turbot/alicloud