turbot/guardrails_insights

Query: guardrails_retention

Usage

powerpipe query guardrails_insights.query.guardrails_retention

SQL

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;

Controls

The query is being used by the following controls: