turbot/aws_well_architected

Query: wellarchitected_workload_risk_count_table

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_risk_count_table

SQL

select
workload_name as "Name",
coalesce((risk_counts ->> 'HIGH')::int, 0) as "High",
coalesce((risk_counts ->> 'MEDIUM')::int, 0) as "Medium",
coalesce((risk_counts ->> 'NONE')::int, 0) as "No Improvements",
coalesce((risk_counts ->> 'NOT_APPLICABLE')::int, 0) as "N/A",
coalesce((risk_counts ->> 'UNANSWERED')::int, 0) as "Unanswered"
from
aws_wellarchitected_workload
order by
"High" desc,
"Medium" desc

Dashboards

The query is used in the dashboards: