turbot/ibm_insights

Query: ibm_compute_instance_by_floating_ip

Usage

powerpipe query ibm_insights.query.ibm_compute_instance_by_floating_ip

Steampipe Tables

SQL

with instances as (
select
case
when jsonb_array_length(floating_ips) = 0 then 'private'
else 'public'
end as visibility
from
ibm_is_instance
)
select
visibility,
count(*)
from
instances
group by
visibility;

Dashboards

The query is used in the dashboards: