turbot/alicloud_insights

Query: ecs_instance_network_interfaces

Usage

powerpipe query alicloud_insights.query.ecs_instance_network_interfaces

Steampipe Tables

SQL

select
p ->> 'NetworkInterfaceId' as "Network Interface ID",
p ->> 'Type' as "Interface Type",
p ->> 'PrimaryIpAddress' as "Primary Ip Address",
private_ip_address as "Private IP Address",
public_ip_address as "Public IP Address",
vpc_id as "VPC ID"
from
alicloud_ecs_instance,
jsonb_array_elements(network_interfaces) as p
where
arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: