turbot/alicloud_insights

Query: ecs_security_group_associated

Usage

powerpipe query alicloud_insights.query.ecs_security_group_associated

Steampipe Tables

SQL

select
name as "Name",
instance_id as "Instance ID",
status as "Status",
instance_type as "Instance Type",
arn as "ARN"
from
alicloud_ecs_instance,
jsonb_array_elements_text(security_group_ids) as sg
where
sg = $1;

Dashboards

The query is used in the dashboards: