View List of Email History from Data Analyzer

[tbonnesen]

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!

[sundas7]

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]

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