turbot/oci_compliance

Query: core_instance_encryption_in_transit_enabled

Usage

powerpipe query oci_compliance.query.core_instance_encryption_in_transit_enabled

SQL

select
i.id as resource,
case
when (launch_options -> 'isPvEncryptionInTransitEnabled')::bool then 'ok'
else 'alarm'
end as status,
case
when (launch_options -> 'isPvEncryptionInTransitEnabled')::bool then i.title || ' encryption in transit enabled.'
else i.title || ' encryption in transit disabled.'
end as reason
, i.region as region, i.tenant_name as tenant
, coalesce(c.name, 'root') as compartment
from
oci_core_instance as i
left join oci_identity_compartment as c on c.id = i.compartment_id;

Controls

The query is being used by the following controls: