Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/13/2022 01:35 AM
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
Solved! Go to Solution.
09/13/2022 03:25 AM
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
09/13/2022 10:11 AM
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.
09/22/2022 09:52 PM
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