Query: Backup plan min frequency and min retention check

Description

Checks if a backup plan has a backup rule that satisfies the required frequency and retention period(35 Days). The rule is non-compliant if recovery points are not created at least as often as the specified frequency or expire before the specified period.

Query

Tables used in this query:

• aws_backup_plan

Controls using this query:

• Backup plan min frequency and min retention check

SQL