turbot/aws_well_architected

Query: wellarchitected_workload_high_issue_count

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_high_issue_count

SQL

with workloads_high_issue_count as (
select
coalesce((risk_counts ->> 'HIGH')::int, 0) as risk_count_high
from
aws_wellarchitected_workload
)
select
sum(risk_count_high) as value,
'Total High Risks' as label,
case
sum(risk_count_high) when 0 then 'ok'
else 'alert'
end as type
from
workloads_high_issue_count;

Dashboards

The query is used in the dashboards: