turbot/steampipe-mod-alicloud-insights

Query: kms_protection_level

Usage

powerpipe query alicloud_insights.query.kms_protection_level

Steampipe Tables

SQL

select
'Protection Level' as label,
initcap(protection_level) as value,
case
when protection_level = 'SOFTWARE' then 'ok'
else 'alert'
end as type
from
alicloud_kms_key
where
arn = $1
and account_id = split_part($1, ':', 4)
and region = split_part($1, ':', 3);

Dashboards

The query is used in the dashboards: