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 complaint 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:

• terraform_resource

Controls using this query:

• Backup plan min frequency and min retention check

SQL