turbot/aws_well_architected

Query: wellarchitected_workload_with_high_issue_count

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_with_high_issue_count

SQL

with workloads_with_high_issues as (
select
workload_id
from
aws_wellarchitected_workload
where
coalesce((risk_counts ->> 'HIGH')::int, 0) > 0
)
select
count(*) as value,
'Workloads with High Risks' as label,
case
count(*) when 0 then 'ok'
else 'alert'
end as type
from
workloads_with_high_issues;

Dashboards

The query is used in the dashboards: