Click HERE to see how Saviynt Intelligence is transforming the industry. |
03/06/2024 06:34 AM
Hello Team,
We need assistance with below use case and need some information around the same :
1. We need to build a report for manager who recieves the details of all his reportee whose end date is approaching.
The report need to run every (30 Days/15 Days/7 Days/3 Days) and provide a consolidated data to manager so that he can action upon the same.
Can you please let me know how to achieve the same?
Solved! Go to Solution.
03/06/2024 09:16 AM
You can write an SQL query to compare current date with end date filed of Saviynt (assuming that end date field is updated with last date of the employee)
Schedule this report as per your requirement.
Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.
03/06/2024 08:03 PM
@dgandhi I have come up with following query :
select
u.username as USER_ID,
u.firstname as FIRSTNAME,
u.lastname as LASTNAME,
u.enddate as ENDDATE,
u.email as EMAIL,
u1.email as MANAGEREMAIL,
u1.username as USERNAME
from users u
join users u1 on u.manager=u1.userkey
WHERE U.STATUSKEY=1
AND U.EMPLOYEETYPE not in ( 'Employee')
AND (DATE(u.enddate) <CURDATE())
ORDER BY USERNAME;
Can you let me know what all variables need to be added in email template so that the only 1 email is received by manager for all those users whose end date is approaching?
I need help with attribute like :
TO
CC
and email body?
03/10/2024 08:43 PM
@dgandhi can you help me with email attributes please?
03/10/2024 08:55 PM
@Manu269 you can refer below link for printing all attributes
03/10/2024 08:56 PM
TO : ${userEmail}
Enable below from Global Configuration - Analytics- Notifications - Group emails by username