turbot/aws_well_architected

Query: wellarchitected_workload_not_applicable_risk_count

Usage

powerpipe query aws_well_architected.query.wellarchitected_workload_not_applicable_risk_count

SQL

select
'Not Applicable' as label,
sum((risk_counts ->> 'NOT_APPLICABLE')::int) as value
from
aws_wellarchitected_lens_review as r
where
r.workload_id = $1
and r.lens_arn = any(string_to_array($2, ','))

Params

ArgsNameDefaultDescriptionVariable
$1workload_id
    $2lens_arn

      Dashboards

      The query is used in the dashboards: