Where do ambari notifications stored

[#1]

Hi,

I would like to know where the email notifications created from Ambari are stored into and how can we access them.

The goal is to use same notification configuration defined in ambari to send other custom notifications from another application.

Can anyone help me to understand the above.

Thanks,

Anil.

[#2]

@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)

.

[#3]

@Anil Reddy

However your query is not very clear can you please explain more about which application are you talking about?

The goal is to use same notification configuration defined in ambari to send other custom notifications from another application.

.