Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Database Table to store Email Triggered

ronit
New Contributor
New Contributor

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 ?

3 REPLIES 3

Saathvik
All-Star
All-Star

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

sk_0-1674574829152.png

Another useful table is emailhistoryprocess.


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Sivagami
Valued Contributor
Valued Contributor

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
All-Star
All-Star

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.


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.