turbot/aws_insights

Query: ebs_volumes_for_ec2_instance

Usage

powerpipe query aws_insights.query.ebs_volumes_for_ec2_instance

SQL

select
v.arn as volume_arn
from
aws_ec2_instance as i,
jsonb_array_elements(block_device_mappings) as bd,
aws_ebs_volume as v
where
v.volume_id = bd -> 'Ebs' ->> 'VolumeId'
and i.arn = $1;