turbot/alicloud_insights

Query: oss_bucket_encrypted_with_servcie_key_count

Usage

powerpipe query alicloud_insights.query.oss_bucket_encrypted_with_servcie_key_count

SQL

select
count(*) as value,
'Encrypted With Service Key' 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 = 'Oss';

Dashboards

The query is used in the dashboards: