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;