Query: codepipeline_pipeline_unencrypted_count

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;