Database Table to store Email Triggered

[ronit]

Hi,

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 ?

[Saathvik]

emailhistory will have all the information like body, to/cc/bcc address, sent date, sent status everything

Another useful table is emailhistoryprocess.

[Sivagami]

Hi @ronit 

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.

https://forums.saviynt.com/t5/identity-governance/which-table-stores-details-of-task-creation-comple... 

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)

-Siva

[rushikeshvartak]

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.vartak@forum.com' order by emailhistorykey desc 

Note : - Task completion and Password email are not stored in this table.