@Anil Reddy
You can find the following tables inside ambari DB:
alerts_history
alerts_current
alerts_notice
Above tables will have the particular alert instance details Like which alert is triggered.
.
However if you want to get the Details about the Alert Notification like Email Alert Notification definition then you can get it from the following table:
alert_target
.
Example:
# psql -U ambari ambari
Password for user ambari: bigdata
ambari=> select * from alert_target;
1 | test_Email | EMAIL | {"mail.smtp.port":"33","mail.smtp.auth":"false","mail.smtp.from":"test_sender@abc.com","mail.smtp.host":"aaa.bbb.com","ambari.dispatch.recipients":["test@abc.com"]}
| Email Notice Desc | 1 | 1
(1 row)
.