turbot/alicloud_insights

Query: ecs_instance_security_groups

Usage

powerpipe query alicloud_insights.query.ecs_instance_security_groups

SQL

select
group_id as "Group ID",
g.name
from
alicloud_ecs_instance as i,
jsonb_array_elements_text(security_group_ids) as group_id
left join alicloud_ecs_security_group as g on g.security_group_id = group_id
where
i.arn = $1
and i.account_id = split_part($1, ':', 5)
and i.region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: