turbot/alicloud_insights

Query: kms_keys_for_ecs_disk

Usage

powerpipe query alicloud_insights.query.kms_keys_for_ecs_disk

SQL

select
k.arn as key_arn
from
alicloud_kms_key k
left join alicloud_ecs_disk as d on k.key_id = d.kms_key_id
where
d.arn = $1
and d.account_id = split_part($1, ':', 5)
and d.region = split_part($1, ':', 4)
and k.arn is not null;