turbot/aws_insights

Query: backup_plan_resource_assignment

Usage

powerpipe query aws_insights.query.backup_plan_resource_assignment

SQL

select
'Resource Assignments' as label,
count(selection_name) as value
from
aws_backup_selection as s,
aws_backup_plan as p
where
s.backup_plan_id = p.backup_plan_id
and p.arn = $1;

Dashboards

The query is used in the dashboards: