Query: core_instance_legacy_metadata_service_endpoint_disabled

select
  i.id as resource,
  case
    when (
      instance_options -> 'areLegacyImdsEndpointsDisabled'
    ) :: bool then 'ok'
    else 'alarm'
  end as status,
  case
    when (
      instance_options -> 'areLegacyImdsEndpointsDisabled'
    ) :: bool then i.title || ' legacy metadata service endpoint disabled.'
    else i.title || '  legacy metadata service endpoint enabled.'
  end as reason,
  i.region as region,
  i.tenant_name as tenant,
  coalesce(c.name, 'root') as compartment
from
  oci_core_instance as i
  left join oci_identity_compartment as c on c.id = i.compartment_id;