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;

Dashboards

The query is used in the dashboards: