turbot/aws_insights

Query: vpc_vpcs_for_efs_file_system

Usage

powerpipe query aws_insights.query.vpc_vpcs_for_efs_file_system

SQL

select
v.vpc_id as vpc_id
from
aws_efs_mount_target as m
left join aws_efs_file_system as f on f.file_system_id = m.file_system_id
left join aws_vpc as v on m.vpc_id = v.vpc_id
where
f.arn = $1;