turbot/ibm_compliance

Query: object_storage_bucket_with_cmk

Usage

powerpipe query ibm_compliance.query.object_storage_bucket_with_cmk

SQL

select
title as resource,
case
when sse_kp_customer_root_key_crn != '<null>' then 'ok'
else 'alarm'
end as status,
case
when sse_kp_customer_root_key_crn != '<null>' then title || ' configured with CMK.'
else title || ' not configured with CMK.'
end as reason,
region,
acc.guid as account_id
from
ibm_cos_bucket,
ibm_account as acc;

Controls

The query is being used by the following controls: