Query: directory_service_certificate_expires_90_days

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;