turbot/aws_compliance

Query: backup_recovery_point_min_retention_35_days

Usage

powerpipe query aws_compliance.query.backup_recovery_point_min_retention_35_days

SQL

select
recovery_point_arn as resource,
case
when (lifecycle -> 'DeleteAfterDays') is null then 'ok'
when (lifecycle -> 'DeleteAfterDays') :: int >= 35 then 'ok'
else 'alarm'
end as status,
case
when (lifecycle -> 'DeleteAfterDays') is null then split_part(recovery_point_arn, ':', -1) || ' retention period set to never expire.'
else split_part(recovery_point_arn, ':', -1) || ' recovery point has a retention period of ' || (lifecycle -> 'DeleteAfterDays') :: int || ' days.'
end as reason,
region,
account_id
from
aws_backup_recovery_point;

Controls

The query is being used by the following controls: