turbot/alicloud_insights

Query: ecs_instance_tags

Usage

powerpipe query alicloud_insights.query.ecs_instance_tags

Steampipe Tables

SQL

select
tag ->> 'TagKey' as "Key",
tag ->> 'TagValue' as "Value"
from
alicloud_ecs_instance,
jsonb_array_elements(tags_src) as tag
where
arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4)
order by
tag ->> 'TagKey';

Dashboards

The query is used in the dashboards: