turbot/alicloud_insights

Query: ecs_network_interfaces_for_ecs_instance

Usage

powerpipe query alicloud_insights.query.ecs_network_interfaces_for_ecs_instance

Steampipe Tables

SQL

select
p ->> 'NetworkInterfaceId' as network_interface_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)
and p ->> 'NetworkInterfaceId' is not null;