Query: dms_certificate_not_expired

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;