turbot/aws_compliance

Query: acm_certificate_no_failed_certificate

Usage

powerpipe query aws_compliance.query.acm_certificate_no_failed_certificate

Steampipe Tables

SQL

select
certificate_arn as resource,
case
when status in ('VALIDATION_TIMED_OUT', 'FAILED') then 'alarm'
else 'ok'
end as status,
title || ' status is ' || status || '.' as reason
, region, account_id
from
aws_acm_certificate;

Controls

The query is being used by the following controls: