Query: compute_instance_public_instance_count

with public_ips as (
  select
    i.title as "title"
  from
    oci_core_instance as i,
    oci_core_vnic_attachment as a
  where
    i.id = a.instance_id and a.public_ip is not null and i.lifecycle_state <> 'TERMINATED'
)
select
  count(*) as value,
  'Public Instances' as label,
  case count(*) when 0 then 'ok' else 'alert' end as "type"
from
  public_ips;