v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins Docs Home

turbot/aws_well_architected

wellarchitected_lens_input wellarchitected_workload_answered_question_count wellarchitected_workload_count wellarchitected_workload_high_issue_count wellarchitected_workload_high_medium_risk_counts wellarchitected_workload_high_risk_count wellarchitected_workload_input wellarchitected_workload_lens_risk_table wellarchitected_workload_medium_issue_count wellarchitected_workload_medium_risk_count wellarchitected_workload_milestone_lens_review_risk_counts wellarchitected_workload_milestone_risk_counts wellarchitected_workload_milestone_risk_table wellarchitected_workload_milestone_unanswered_table wellarchitected_workload_no_improvements_risk_count wellarchitected_workload_not_applicable_risk_count wellarchitected_workload_pillar_risk_table wellarchitected_workload_risk_count_table wellarchitected_workload_risks_by_lens wellarchitected_workload_risks_by_milestone wellarchitected_workload_risks_by_pillar wellarchitected_workload_unanswered_by_milestone wellarchitected_workload_with_high_issue_count wellarchitected_workload_with_medium_issue_count

Query: wellarchitected_workload_risks_by_lens

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_risks_by_lens

Steampipe Tables

aws_wellarchitected_lens_review

Amazon Web Services plugin

SQL

select
  r.lens_name,
  (r.risk_counts ->> 'HIGH')::int as high_risks,
  (r.risk_counts ->> 'MEDIUM')::int as medium_risks,
  (r.risk_counts ->> 'NONE')::int as no_improvements_risks,
  (r.risk_counts ->> 'NOT_APPLICABLE')::int as not_applicable_risks
from
  aws_wellarchitected_lens_review as r
where
  r.workload_id = $1
  and r.lens_arn = any(string_to_array($2, ','))
group by
  r.lens_name,
  r.risk_counts
order by
  r.lens_name

Params

Args	Name	Default	Description	Variable
$1	workload_id
$2	lens_arn

Dashboards

The query is used in the dashboards:

AWS Well-Architected Workload Detail