Query: smart_retention

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