turbot/aws_well_architected

Query: wellarchitected_workload_medium_issue_count

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_medium_issue_count

SQL

with workloads_medium_issue_count as (
select
coalesce((risk_counts ->> 'MEDIUM')::int, 0) as risk_count_medium
from
aws_wellarchitected_workload
)
select
sum(risk_count_medium) as value,
'Total Medium Risks' as label,
case
sum(risk_count_medium) when 0 then 'ok'
else 'alert'
end as type
from
workloads_medium_issue_count;

Dashboards

The query is used in the dashboards: