Query: mod_health_benchmark

select
  split_part(resource_trunk_title, '>', 2) as resource,
  case 
    when state in ('tbd', 'invalid') then 'info'
    else state
  end as status,
  case
    when state = 'ok' then split_part(resource_trunk_title, '>', 2) || ' is healthy.'
    else split_part(resource_trunk_title, '>', 2) || ' ' || reason || '.'
  end as reason
  , split_part(workspace, '//', 2) as workspace
from
  guardrails_control
where
  control_type_uri = 'tmod:@turbot/turbot#/control/types/modHealth'
group by
  workspace, id, state, resource_trunk_title, reason
order by
  workspace;