Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/09/2024 03:06 AM
Hi All,
We have a requirement for one of the application (endpoint) where we have to send emails to all accounts where the particular entitlement value assigned to them have end date and is approaching to let users know their access will revoke automatically
For example: User1 have ent1 in application 'XYZ' and User2 have ent2
User1 - Ent1: End date is 1 Jan 2025
User2 - Ent2: End date is 10 Jan 2025
We have to send separate emails to both showing end date and respective entitlement value.
I understand we can achieve it using analytics and create a report but how to send individual emails to only respective users?
Any format of email would be helpful please where we are fetching data from analytics report and inserting in To, body of email
08/09/2024 03:22 AM - edited 08/09/2024 03:30 AM
@varunakarnia keep a column username which will have username of ther users whose entitlement are going to expire in future. Fetch all relevant columns from query to email.
Now in To field add ${userEmail} it will automatically send to the respective user
08/09/2024 03:28 AM - edited 08/09/2024 03:32 AM
TO: ${userEmail}
This is how you can use binding variables to fetch data from query in your mail templates:
${ANALYTICSDATAMAP.get("endusername")}
${ANALYTICSDATAMAP.get("enddate")}
endusername and enddate are column names that you'll use in your select query.
08/09/2024 03:30 AM
Check this post for further assistance:
08/09/2024 06:31 AM
Use global configuration and OOTB report for entitlement expiry
Days to notify before entitlement expires