turbot/aws_compliance

Query: eks_cluster_no_multiple_security_groups

Usage

powerpipe query aws_compliance.query.eks_cluster_no_multiple_security_groups

Steampipe Tables

SQL

select
arn as resource,
case
when jsonb_array_length(resources_vpc_config -> 'SecurityGroupIds') > 1 then 'alarm'
else 'ok'
end as status,
title || ' has ' || jsonb_array_length(resources_vpc_config -> 'SecurityGroupIds') || ' security group(s).' as reason,
region,
account_id
from
aws_eks_cluster;

Controls

The query is being used by the following controls: