turbot/aws_compliance

Query: iam_server_certificate_not_expired

Usage

powerpipe query aws_compliance.query.iam_server_certificate_not_expired

SQL

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

Controls

The query is being used by the following controls: