Query: guardrails_activity_retention

select
  ws.workspace,
  ps.id as resource,
  case
    when ps.value is null
    or ps.value = '' then 'alarm'
    when ps.value = 'None' then 'alarm'
    else 'ok'
  end as status,
  case
    when ps.value is null
    or ps.value = '' then 'Policy recommendation not met'
    when ps.value = 'None' then 'Policy recommendation not met'
    else 'ok'
  end as reason
from
  (
    select
      distinct workspace
    from
      guardrails_policy_setting
  ) ws
  left join guardrails_policy_setting ps on ws.workspace = ps.workspace
  and ps.policy_type_uri = 'tmod:@turbot/turbot#/policy/types/activityRetention'
order by
  ws.workspace;