turbot/aws_insights

Query: vpc_security_groups_for_efs_file_system

Usage

powerpipe query aws_insights.query.vpc_security_groups_for_efs_file_system

SQL

select
jsonb_array_elements_text(t.security_groups) as security_group_id
from
aws_efs_file_system as s,
aws_efs_mount_target as t
where
s.file_system_id = t.file_system_id
and s.arn = $1
and s.account_id = split_part($1, ':', 5)
and s.region = split_part($1, ':', 4);