turbot/aws_well_architected

Query: wellarchitected_workload_high_medium_risk_counts

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_high_medium_risk_counts

SQL

-- Get current risk counts
select
workload_id,
workload_name,
coalesce((workload -> 'RiskCounts' ->> 'HIGH')::int, 0) as high_risks,
coalesce((workload -> 'RiskCounts' ->> 'MEDIUM')::int, 0) as medium_risks
from
aws_wellarchitected_workload
group by
workload_name,