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_milestone_risk_counts

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_milestone_risk_counts

Steampipe Tables

aws_wellarchitected_milestone

aws_wellarchitected_workload

Amazon Web Services plugin

SQL

-- Get current risk counts
select
  workload_id,
  workload_name,
  'latest' as milestone_name,
  101 as milestone_number, -- 100 milestone max for workloads
  updated_at as recorded_at,
  risk_counts
from
  aws_wellarchitected_workload
union
-- Get past milestone risk counts
select
  workload_id,
  workload ->> 'WorkloadName' as workload_name,
  milestone_name,
  milestone_number,
  recorded_at,
  workload -> 'RiskCounts' as risk_counts
from
  aws_wellarchitected_milestone
order by
  workload_id,
  milestone_number