wellarchitected_lens_inputwellarchitected_workload_answered_question_countwellarchitected_workload_countwellarchitected_workload_high_issue_countwellarchitected_workload_high_medium_risk_countswellarchitected_workload_high_risk_countwellarchitected_workload_inputwellarchitected_workload_lens_risk_tablewellarchitected_workload_medium_issue_countwellarchitected_workload_medium_risk_countwellarchitected_workload_milestone_lens_review_risk_countswellarchitected_workload_milestone_risk_countswellarchitected_workload_milestone_risk_tablewellarchitected_workload_milestone_unanswered_tablewellarchitected_workload_no_improvements_risk_countwellarchitected_workload_not_applicable_risk_countwellarchitected_workload_pillar_risk_tablewellarchitected_workload_risk_count_tablewellarchitected_workload_risks_by_lenswellarchitected_workload_risks_by_milestonewellarchitected_workload_risks_by_pillarwellarchitected_workload_unanswered_by_milestonewellarchitected_workload_with_high_issue_countwellarchitected_workload_with_medium_issue_count
Query: wellarchitected_workload_high_medium_risk_counts
Usage
powerpipe query aws_well_architected.query.wellarchitected_workload_high_medium_risk_countsSQL
-- Get current risk countsselect workload_id, workload_name, coalesce((workload -> 'RiskCounts' ->> 'HIGH')::int, 0) as high_risks, coalesce((workload -> 'RiskCounts' ->> 'MEDIUM')::int, 0) as medium_risksfrom aws_wellarchitected_workloadgroup by workload_name,