Hana alert log errors are available within the _SYS_STATISTICS.STATISTICS_CURRENT_ALERTS system table. This alert queries the data that have occurred since the alert last executed. If the execution frequency is 10 minutes, only errors from the last 10 minutes are retrieved.
Use this screenshot as a template the alert and the attached query for the SQL statement: