Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Mail not getting sent due to issue with Analytics Data

PRATYUSH1
New Contributor III
New Contributor III

Hi,

 

We are trying to send a mail to the managers of the users regarding the Contractor Expiries of their users using analytics. Currently, we store the manager emails of the users in customproperty16 and trying to add in the analytics and email templates. The issue we are facing is the inconsistent behaviour of the email template.

Emails do not get sent everytime. And every time email is sent, one of the managers gets the same email twice. This is completely random and we cannot determine who will receive the duplicate email.

Can you please help with issue?

 

 

The analytics we are using is:

select u.displayname as "DisplayName", u.email, u.enddate as "End Date", u.startdate as "Start Date", u.customproperty16 as "ManagerEmail", u.username as username from users u where u.employeetype not in ('Permanent Employee','Colleague') and u.enddate > CURDATE() AND u.enddate < DATE_ADD(CURDATE(), INTERVAL 30 DAY)

 

 

The To and CC fields of the email templates are:

To: ${userEmail}

cc: ${ANALYTICSDATA.'ManagerEmail'[0]}

1 REPLY 1

rushikeshvartak
All-Star
All-Star
  • How frequently job/ report is scheduled 

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.