turbot/alicloud_insights

Query: ecs_security_groups_for_ecs_instance

Usage

powerpipe query alicloud_insights.query.ecs_security_groups_for_ecs_instance

Steampipe Tables

SQL

select
group_id as security_group_id
from
alicloud_ecs_instance as i,
jsonb_array_elements_text(security_group_ids) as group_id
where
i.account_id = split_part($1, ':', 5)
and i.region = split_part($1, ':', 4)
and i.arn = $1;