turbot/oci_insights

Query: compute_instance_public

Usage

powerpipe query oci_insights.query.compute_instance_public

Steampipe Tables

SQL

select
case
when title = '' then 'Disabled'
else 'Enabled'
end as value,
'Public Access' as label,
case
when title = '' then 'ok'
else 'alert'
end as type
from
oci_core_vnic_attachment
where
instance_id = $1
and public_ip is not null;

Dashboards

The query is used in the dashboards: