send emails to the users filtered in the SQL query through analytics

[asharma]

Hi Team,

I want to send an email template to particular user's manager reminding about users end date is after 14 days. Can we do it through Analytics or user update rules and how?

[rushikeshvartak]

You can do same with analytics

Refer 

Example 6: Email to list all the managers and the details of their sub-ordinates. Manager receives a single email with the details of all the sub-ordinates. 

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter06-EIC-Configurations/Creati...

[asharma]

cool and how to create that analytics.

[rushikeshvartak]

• use SQL query
• Change as per your needs

• SELECT U.username AS username ,U.firstname AS 'First Name' ,U.lastname AS 'Last Name' ,U.email AS 'User email' ,date_format(u.enddate,"%Y-%m-%d %H:%I:%S") as 'End Date',( SELECT CONCAT ( firstname ,' ' ,lastname ) FROM users WHERE U.manager = userkey ) AS 'Manager Name' ,( SELECT email FROM users WHERE U.manager = userkey ) AS 'Manager email' FROM users U WHERE u.employeetype IN ('Contractor') AND u.statuskey = 1 AND datediff(enddate, now()) = 15

[asharma]

how a email template or a analytic know which email template to trigger or which analytic will get trigger by email template.

[rushikeshvartak]

• You need to attach email template to analytics report. Steps are listed in same link 
• Sample
• 

[asharma]

I am not getting this option of email template. How I'll get this.

After making the changes in Global config. Does it require a restart.?

[rushikeshvartak]

• Refer below
•