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.
Thanks
Rupesh Chavan