turbot/aws_insights

Query: target_ebs_snapshots_for_ebs_volume

Usage

powerpipe query aws_insights.query.target_ebs_snapshots_for_ebs_volume

SQL

select
s.snapshot_id
from
aws_ebs_volume as v,
aws_ebs_snapshot as s
where
s.volume_id = v.volume_id
and v.arn = $1
and v.account_id = split_part($1, ':', 5)
and v.region = split_part($1, ':', 4);