Control: Turbot > Workspace > Retention

Description

Check the policy values for guardrails workspace retention

Usage

Run the control in your terminal:

powerpipe control run guardrails_insights.control.guardrails_workspace_retention

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run guardrails_insights.control.guardrails_workspace_retention --share

SQL

This control uses a named query:

select
  workspace,
  id as resource,
  case
    when value = 'Enforce: Enable purging via Smart Retention' then 'ok'
    else 'alarm'
  end as status,
  case
    when value = 'Enforce: Enable purging via Smart Retention' then 'Policy recommendation met'
    else 'Policy recommendation not met'
  end as reason
from
  guardrails_policy_setting
where
  policy_type_uri = 'tmod:@turbot/turbot#/policy/types/retention'
order by
  workspace;