turbot/oci_insights

Query: filestorage_filesystem_encryption

Usage

powerpipe query oci_insights.query.filestorage_filesystem_encryption

SQL

select
k.name as "Key Name",
case
when kms_key_id is not null
and kms_key_id <> '' then 'Customer Managed'
else 'Oracle Managed'
end as "Encryption Status",
kms_key_id as "KMS Key ID"
from
oci_file_storage_file_system as s
left join oci_kms_key as k on s.kms_key_id = k.id
where
s.id = $1;

Dashboards

The query is used in the dashboards: