turbot/aws_well_architected

Query: wellarchitected_workload_risks_by_lens

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_risks_by_lens

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

ArgsNameDefaultDescriptionVariable
$1workload_id
    $2lens_arn

      Dashboards

      The query is used in the dashboards: