Query: Backup report plan should exist in a region where backup plan is enabled

Description

Ensure that there is a minimum of one backup report plan in each region. The rule will be considered non-compliant if a region with backup plans does not have any backup report plans.

Query

Tables used in this query:

• aws_backup_plan
• aws_backup_report_plan
• aws_region

Controls using this query:

• Backup report plan should exist in a region where backup plan is enabled

SQL