turbot/alicloud_insights

Query: oss_bucket_encrypted_with_byok_count

Usage

powerpipe query alicloud_insights.query.oss_bucket_encrypted_with_byok_count

SQL

select
count(*) as value,
'Encrypted With BYOK' as label
from
alicloud_oss_bucket b
left join alicloud_kms_key k on b.server_side_encryption ->> 'KMSMasterKeyID' = k.key_id
where
server_side_encryption ->> 'SSEAlgorithm' = 'KMS' and k.creator = k.account_id;

Dashboards

The query is used in the dashboards: