Azure and GCP Perimeter Security, CIS Updates, and Enhanced Plugins →

Plugins Docs Home

turbot/steampipe-mod-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_with_medium_issue_count

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_with_medium_issue_count

Steampipe Tables

aws_wellarchitected_workload

AWS plugin

SQL

with workloads_with_medium_issues as (
  select
    workload_id
  from
    aws_wellarchitected_workload
  where
  coalesce((risk_counts ->> 'MEDIUM')::int, 0) > 0
)
select
  count(*) as value,
  'Workloads with Medium Risks' as label,
  case
    count(*) when 0 then 'ok'
    else 'alert'
  end as type
from
  workloads_with_medium_issues;

Dashboards

The query is used in the dashboards:

AWS Well-Architected Workload Risks Report