Query: compute_instance_monitoring

with instance_monitoring as (
  select
    distinct display_name
  from
    oci_core_instance,
    jsonb_array_elements(agent_config -> 'pluginsConfig') as config
  where
    config ->> 'name' = 'Compute Instance Monitoring'
    and config ->> 'desiredState' = 'ENABLED'
)
select
  'Monitoring' as label,
  case
    when m.display_name is null then 'Disabled'
    else 'Enabled'
  end as value,
  case
    when m.display_name is null then 'alert'
    else 'ok'
  end as type
from
  oci_core_instance as i
  left join instance_monitoring as m on i.display_name = m.display_name
where
  i.id = $1;