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]}
