turbot/aws_insights

Query: vpc_subnets_for_efs_file_system

Usage

powerpipe query aws_insights.query.vpc_subnets_for_efs_file_system

SQL

select
s.subnet_id as subnet_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_subnet as s on m.subnet_id = s.subnet_id
where
f.arn = $1;