turbot/alicloud_insights

Query: ecs_disks_for_kms_key

Usage

powerpipe query alicloud_insights.query.ecs_disks_for_kms_key

SQL

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