turbot/aws_compliance

Query: dms_certificate_not_expired

Usage

powerpipe query aws_compliance.query.dms_certificate_not_expired

Steampipe Tables

SQL

select
arn as resource,
case
when valid_to_date < (current_date - interval '1' second) then 'alarm'
else 'ok'
end as status,
case
when valid_to_date < (current_date - interval '1' second) then
title || ' expired ' || to_char(valid_to_date, 'DD-Mon-YYYY') || '.'
else
title || ' valid until ' || to_char(valid_to_date, 'DD-Mon-YYYY') || '.'
end as reason
, account_id
from
aws_dms_certificate;

Controls

The query is being used by the following controls: