Query: compute_instance_monitoring_disabled_count

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' = 'DISABLED'
    and lifecycle_state <> 'TERMINATED'
)
select
  count(*) as value,
  'Monitoring Disabled' as label,
  case
    count(*)
    when 0 then 'ok'
    else 'alert'
  end as type
from
  instance_monitoring;