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_risk_count_table
Usage
powerpipe query aws_well_architected.query.wellarchitected_workload_risk_count_tableSteampipe Tables
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_workloadorder by "High" desc, "Medium" desc
Dashboards
The query is used in the dashboards: