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_no_improvements_risk_count
Usage
powerpipe query aws_well_architected.query.wellarchitected_workload_no_improvements_risk_countSteampipe Tables
SQL
select 'No Improvements' as label, sum((risk_counts ->> 'NONE')::int) as valuefrom aws_wellarchitected_lens_review as rwhere r.workload_id = $1 and r.lens_arn = any(string_to_array($2, ','))
Params
| Args | Name | Default | Description | Variable |
|---|---|---|---|---|
| $1 | workload_id | |||
| $2 | lens_arn |
Dashboards
The query is used in the dashboards: