turbot/aws_insights

Query: vpc_security_attached_enis_count

Usage

powerpipe query aws_insights.query.vpc_security_attached_enis_count

SQL

select
'Attached ENIs' as label,
count(*) as value,
case when count(*) > 0 then 'ok' else 'alert' end as type
from
aws_ec2_network_interface,
jsonb_array_elements(groups) as sg
where
sg ->> 'GroupId' = $1;

Dashboards

The query is used in the dashboards: