How to check email send failed scenario in Saviynt?

[rushikeshvartak]

Under admin - email history viewer option

[anjali_5]

Hi Rushikesh,

                        There is no failed email record showing in Email history viewer. Is there any other way to fetch the email send failed report ?

[rushikeshvartak]

select * from emailhistory_archive 

SELECT
    ACCESS_APPROVERS,
    ACTIVITYNAME,
    BCCADDRESS,
    BODYOFEMAIL,
    CCADDRESS,
    CREATEDATE,
    EMAILTEMPLATE,
    ENDPOINTKEY,
    FROMADDRESS,
    JBPMEXECUTIONID,
    MAILSENTDATE,
    PROCESSINSTANCEID,
    REQUEST_ACCESS,
    STATUS S,
    SUBJECTOFEMAIL,
    TOADDRESS,
    UUID,
    RETRYCOUNT,
    SOURCE,
    FILEPARAMS
FROM
    emailhistory_archive;

Note : Run from analytics 

[NM]

Hi @anjali_5 you can refer emailhistory and emailhistoryarchive table for the same

5,144 are one of the status code for failure.

[anjali_5]

After providing the above query , record count is showing while clicking on "Dry Run" but it's taking time while clicking on "Run Now" and no record is showing .

[rushikeshvartak]

Table contains data in GB and hence please use required filter on request id 

[anjali_5]

How can I able to configure email history viewer since there is no records due to which I am not able to test email send failed OOTB reports ?

[rushikeshvartak]

Failed OOTB if its email sent from analytics then its not stored in email history table. You need to track from application logs. Email history stores email sent from access requests only.

[anjali_5]

Hi,

I need a query to fetch all failed emails which are send from both analytics and access request . Also, in both application logs and email history viewer , there are no records of failed email templates. Then what is the next step to fetch failed email records through OOTB email send failed analytical reports ?

Thanks,

Anjali

[rushikeshvartak]

• Email sent from analytics report are not stored in database table hence you can't find same.

[anjali_5]

I have written below query to check failed email in data analyzer but it's giving output is same with and without providing status attribute.

select NAME AS 'EMAIL_TEMPLATE',CREATEDATE,mailfrom,MAILTO,mailsubject AS 'Subject',MAILSENTDATE,status as Emailstatus ,eh.EMAILFAILURELOGS from emailhistory eh, ecmemailtemplate et where eh.status=5;

Can you please tell why the output is same in both the case?

[rushikeshvartak]

• Same output can you elaborate ?

[anjali_5]

Query1:select NAME AS 'EMAIL_TEMPLATE',CREATEDATE,mailfrom,MAILTO,mailsubject AS 'Subject',MAILSENTDATE,status as Emailstatus ,eh.EMAILFAILURELOGS from emailhistory eh, ecmemailtemplate et where eh.status=5;

Total record :350

Query 2: select NAME AS 'EMAIL_TEMPLATE',CREATEDATE,mailfrom,MAILTO,mailsubject AS 'Subject',MAILSENTDATE,status as Emailstatus ,eh.EMAILFAILURELOGS from emailhistory eh, ecmemailtemplate et

Total record :350

In both the case , total record is same . Adding status attribute in the query has not changed the output count.

[rushikeshvartak]

What is expected behavior ? as mentioned analytics email will not be visible as those are not stored in database