OEM sent emails alert history

Sometimes you need to get list of alerts incidents that sent from Oracle Enterprise Manager - OEM for audit team or something else, It is time consuming to find all sent emails in E-mail, therefore here is script which you can use in Oracle Enterprise Manager repository database for get this information:

select a.TARGET_NAME,
       a.target_type,
       a.message,
       a.alert_state,
       a.collection_timestamp,
       a.delivery_message
  from SYSMAN.MGMT$ALERT_NOTIF_LOG a
 where a.collection_timestamp >=
       to_date('01-05-2017 00:00:00', 'DD-MM-YYYY HH24:MI:SS') --sent alerts after 01-APRIL-2017
 order by a.collection_timestamp asc;