turbot/oci_insights

Query: vcn_subnet_flow_logs

Usage

powerpipe query oci_insights.query.vcn_subnet_flow_logs

SQL

select
case
when is_enabled then 'Enabled'
else 'Disabled'
end as value,
'Flow Logs' as label,
case
when is_enabled then 'ok'
else 'alert'
end as type
from
oci_core_subnet as s
left join oci_logging_log as l on s.id = l.configuration -> 'source' ->> 'resource'
where
s.id = $1
and s.lifecycle_state <> 'TERMINATED';

Dashboards

The query is used in the dashboards: