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: