turbot/alicloud_insights

Query: vpc_eips_for_ecs_instance

Usage

powerpipe query alicloud_insights.query.vpc_eips_for_ecs_instance

SQL

select
e.arn as eip_arn
from
alicloud_ecs_instance i
left join alicloud_vpc_eip as e on i.instance_id = e.instance_id
where
i.arn = $1
and i.account_id = split_part($1, ':', 5)
and i.region = split_part($1, ':', 4)
and e.arn is not null;