01-24-2023 07:33 AM
We have a requirement to fetch whether the email was successfully sent upon successful completion of an account creation.
The email template is attached to the endpoint.
When the task was completed successfully, and when the email was triggered successfully, which database table/column stores the info regarding the email being sent successfully for that respective task ?
01-24-2023 07:40 AM
emailhistory will have all the information like body, to/cc/bcc address, sent date, sent status everything
Another useful table is emailhistoryprocess.
01-24-2023 10:35 AM
Task creation / completion emails are stateless, Saviynt does not save the audit trail of all the emails sent in any of the tables. Refer this forums post for more clarity.
emailhistory table basically stores the sent log of all the emails that are associated in the workflows (Approval emails / reminder emails / grant or reject block emails)
01-24-2023 12:40 PM - edited 01-24-2023 12:41 PM
Pending Emails to be sent :
select SUBJECTOFEMAIL,TOADDRESS,CCADDRESS,BODYOFEMAIL,PROCESSINSTANCEID from EMAILHISTORY
Sent Emails :
select SUBJECTOFEMAIL,TOADDRESS,CCADDRESS,BODYOFEMAIL,PROCESSINSTANCEID from EMAILHISTORY_ARCHIVE where TOADDRESS ='Rushikesh.email@example.com' order by emailhistorykey desc
Note : - Task completion and Password email are not stored in this table.