Sending emails to account's users where particular entitlement's end date is approaching

[varunakarnia]

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

[NM]

@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

[Abhishek0406]

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.

[Abhishek0406]

Check this post for further assistance:

https://forums.saviynt.com/t5/saviynt-knowledge-base/leverage-analytics-to-send-mails-to-users-indiv...

[rushikeshvartak]

Use global configuration and OOTB report for entitlement expiry

Days to notify before entitlement expires

Specify the number of days before the entitlement expiration date that the user receives an expiry notification