turbot/alicloud_insights

Query: ecs_snapshot_encryption_status

Usage

powerpipe query alicloud_insights.query.ecs_snapshot_encryption_status

SQL

select
s.kms_key_id as "KMS Key ID",
k.protection_level as "Protection Level",
k.primary_key_version as "Key Version"
from
alicloud_ecs_snapshot as s,
alicloud_kms_key as k
where
s.kms_key_id = k.key_id
and s.arn = $1
and s.account_id = split_part($1, ':', 5)
and s.region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: