turbot/aws_insights

Query: codepipeline_pipeline_unencrypted_count

Usage

powerpipe query aws_insights.query.codepipeline_pipeline_unencrypted_count

SQL

select
count(*) as value,
'Unencrypted' as label,
case
when count(*) > 0 then 'alert' else 'ok' end as "type"
from
aws_codepipeline_pipeline
where
encryption_key is null;

Dashboards

The query is used in the dashboards: