Query: compute_instance_public

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;