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

View List of Email History from Data Analyzer

tbonnesen
New Contributor II
New Contributor II

Is there a table other than the emailhistory that holds a list of the emails that have been sent out? I am getting a "No Data Found" when searching for any data on this table.

select *
from emailhistoryprocess

Thank you!

2 REPLIES 2

sundas7
Regular Contributor II
Regular Contributor II

Hi,

Please check if this helps. There was already a similar question posted.

https://forums.saviynt.com/t5/identity-governance/sql-query-to-check-if-emails-are-sent/m-p/7340#M34...

select SUBJECTOFEMAIL,TOADDRESS,CCADDRESS,BODYOFEMAIL,PROCESSINSTANCEID from EMAILHISTORY_ARCHIVE where TOADDRESS ='email@email.com' order by emailhistorykey desc limit 10

Thanks

Shyam

 

 

rushikeshvartak
All-Star
All-Star

emailhistoryprocess : When an Email History job is run, emails are processed and moved to EmailhistoryProcess.

EMAILHISTORY_ARCHIVE - Emails that are successfully processed from EmailhistoryProcess are moved to the EmailHistory_archive table

EMAILHISTORY - emails that are not processed are moved to the EmailHistory table.

Reference : https://saviynt.freshdesk.com/support/solutions/articles/43000654902-release-notes-v5-5-sp3-11

 

 

select SUBJECTOFEMAIL,TOADDRESS,CCADDRESS,BODYOFEMAIL,PROCESSINSTANCEID from EMAILHISTORY_ARCHIVE where TOADDRESS ='email@email.com' order by emailhistorykey desc limit 10

 


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