Help to identify the email triggered?

[Manu269]

Hi Team,

As a part of configuration, we have setup email templates for following case :

1. Request submission : End User

2. Request Approval : End User and Approver.

We were notified by the approver that when the request was submitted successfully, they did not receive the email. Can someone assist how can we identify in SSM if the email was triggered successfully?

I am having the request ID only from the requestor.

Thanks

[rushikeshvartak]

If emails are attached & one of the approved does not receive. You need to dig log or use below query

Select SUBJECTOFEMAIL,TOADDRESS,CCADDRESS,BODYOFEMAIL,PROCESSINSTANCEID from EMAILHISTORY_ARCHIVE where TOADDRESS ='Rushikesh@forum.com' order by emailhistorykey desc 

[Belwyn]

Hi @Manu269 

Thank you for reaching out to us, 

Approver notification email templates are being at the workflow level. To check if the email template is being triggered please check the logs. 

Thanks & Regards, 

Belwyn.

[Manu269 · Accepted solution]

Hi Team,

I have achieved to identify the same via creating an analytics to review the failed email.

SELECT ea.emailhistorykey AS 'Email History Key', SUBSTRING_INDEX(ar.jbpmprocessinstanceid, '.', - 1) AS 'Request ID', ea.toaddress AS 'TO Address', mailsentdate AS 'Mail Send Date', emailtemplate AS 'Email Template', ea.status as 'Email Delivery Status' FROM emailhistory_archive ea INNER JOIN request_access ra ON ea.request_access = ra.request_accesskey INNER JOIN ars_requests ar ON ar.requestkey = ra.requestkey WHERE ar.status=1