Report to Manager || Reportee end date is approaching

[Manu269]

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?

[dgandhi]

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.

[Manu269]

@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?

[Manu269]

@dgandhi can you help me with email attributes please?

[CR]

@Manu269  you can refer below link for printing all attributes

https://forums.saviynt.com/t5/identity-governance/how-to-fetch-user-s-manager-email-in-email-templat...

[rushikeshvartak · Accepted solution]

TO : ${userEmail}

Enable below from  Global Configuration - Analytics- Notifications - Group emails by username