turbot/aws_insights

Query: backup_plan_rules

Usage

powerpipe query aws_insights.query.backup_plan_rules

Steampipe Tables

SQL

select
r ->> 'RuleId' as "Rule ID",
r ->> 'RuleName' as "Rule Name",
r -> 'Lifecycle' as "Lifecycle",
r -> 'CopyActions' as "Copy Actions",
r -> 'RecoveryPointTags' as "Recovery Point Tags",
r -> 'ScheduleExpression' as "Schedule Expression",
r -> 'StartWindowMinutes' as "Start Window Minutes",
r -> 'EnableContinuousBackup' as "EnableContinuousBackup",
r -> 'CompletionWindowMinutes' as "Completion Window Minutes"
from
aws_backup_plan,
jsonb_array_elements(backup_plan -> 'Rules') as r
where
account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4)
and arn = $1;

Dashboards

The query is used in the dashboards: