turbot/aws_insights

Query: efs_mount_targets_for_efs_file_system

Usage

powerpipe query aws_insights.query.efs_mount_targets_for_efs_file_system

SQL

with efs_details as (
select
file_system_id
from
aws_efs_file_system
where
arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4)
)
select
mt.mount_target_id
from
aws_efs_mount_target mt
join
efs_details ed on mt.file_system_id = ed.file_system_id;