turbot/aws_insights

Query: codepipeline_pipeline_encryption_status

Usage

powerpipe query aws_insights.query.codepipeline_pipeline_encryption_status

SQL

select
encryption_status,
count(*)
from
(
select
encryption_key,
case
when encryption_key is not null then 'enabled'
else 'disabled'
end encryption_status
from
aws_codepipeline_pipeline
) as t
group by
encryption_status
order by
encryption_status desc;

Dashboards

The query is used in the dashboards: