turbot/aws_insights

Query: efs_access_points_for_efs_file_system

Usage

powerpipe query aws_insights.query.efs_access_points_for_efs_file_system

SQL

with efs_file_system_id 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
a.access_point_arn as access_point_arn
from
aws_efs_access_point a
join
efs_file_system_id efs on efs.file_system_id = a.file_system_id;