turbot/aws_compliance

Query: directory_service_certificate_expires_90_days

Usage

powerpipe query aws_compliance.query.directory_service_certificate_expires_90_days

SQL

select
certificate_id as resource,
case
when date(expiry_date_time) - date(current_date) >= 90 then 'ok'
else 'alarm'
end as status,
title || ' expires ' || to_char(expiry_date_time, 'DD-Mon-YYYY') ||
' (' || extract(day from expiry_date_time - current_date) || ' days).' as reason
, region, account_id
from
aws_directory_service_certificate;

Controls

The query is being used by the following controls: