turbot/alicloud_insights

Query: kms_key_aliases

Usage

powerpipe query alicloud_insights.query.kms_key_aliases

Steampipe Tables

SQL

select
p ->> 'AliasArn' as "Alias Arn",
p ->> 'AliasName' as "Alias Name",
p ->> 'KeyId' as "Key ID"
from
alicloud_kms_key,
jsonb_array_elements(key_aliases) as p
where
arn = $1
and account_id = split_part($1,':',4)
and region = split_part($1,':',3);

Dashboards

The query is used in the dashboards: