turbot/ibm_insights

Query: ibm_compute_public_instance

Usage

powerpipe query ibm_insights.query.ibm_compute_public_instance

Steampipe Tables

SQL

select
'Public Access' as label,
case
when jsonb_array_length(floating_ips) <> 0 then 'Enabled'
else 'Disabled'
end as value,
case
When jsonb_array_length(floating_ips) <> 0 then 'alert'
else 'ok'
end as "type"
from
ibm_is_instance
where
crn = $1;

Params

ArgsNameDefaultDescriptionVariable
$1crn

    Dashboards

    The query is used in the dashboards: