How to checks alerts history in HANA Database ?

 Hi Everyone,

In this blog, we are going to see a small but important point. How to check alert history for the last two months? 

Note: There are many views that will help us to alert details but only one view will provide you the history of the last few months. 

Please follow below steps. 

1: Open HANA studio and open SQL console with user with right to execute select query. 

2: Run below SQL statement which will help you to get alters of that HOST. 

select * from "_SYS_STATISTICS"."STATISTICS_ALERTS" where alert_id=5 order by alert_timestamp desc

Get more details about HANA database alerts from below link.

HANA database alerts details

Thanks

Rupesh Chavan