turbot/aws_well_architected

Query: wellarchitected_workload_medium_risk_count

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_medium_risk_count

SQL

select
'Medium Risks' as label,
sum((risk_counts ->> 'MEDIUM')::int) as value,
case
sum((risk_counts ->> 'MEDIUM')::int) when 0 then 'ok'
else 'alert'
end as type
from
aws_wellarchitected_lens_review as r
where
r.workload_id = $1
and r.lens_arn = any(string_to_array($2, ','))

Params

ArgsNameDefaultDescriptionVariable
$1workload_id
    $2lens_arn

      Dashboards

      The query is used in the dashboards: