Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/07/2024 11:23 PM - edited 10/07/2024 11:34 PM
Hi Team,
We have a requirement where, when a user raises a request for an application, they are required to select an entitlement end date. Once the user is granted the entitlement, we have an analytics process in place that collects data on entitlements that are set to expire within 3 days. One mail is attached with the analytics, and it will notify the user and include their manager in CC using an email template attached to the analytics.
The notification is intended to remind both the user (in "To") and their manager (in "CC") that the entitlement is about to expire 3 days prior to the end date. However, we have encountered an issue where the manager’s email is not being fetched correctly by the email template, and only the user is receiving the notification in the "To" field.
We have attempted to use the following variables for fetching the manager’s email, but none have worked so far:
For the user, we have successfully used ${user.email}, which is working perfectly.
Could you please assist in resolving this issue so that the manager's email is included in the CC as intended?
Best regards,
Sabyasachi Mohanty
10/07/2024 11:32 PM
@sabyasachi1 how analytics prepared , in query manager column are using ?
10/07/2024 11:35 PM
@sabyasachi1 Provide your analytics query.
10/07/2024 11:36 PM
Hi @Raghu
One mail is attached with the analytics and it will notify the user and manager in CC.
10/07/2024 11:43 PM
@sabyasachi1 try like below
query like:
select u.username,u.email as 'manageremail',u.username as 'globalid' from users
to: ${user.email}
cc:
${ANALYTICSDATA.'manageremail'[0]},
10/07/2024 11:40 PM
Hi @pmahalle ,
This query retrieves the end date of an entitlement which going to expire in 3 days for that user. Upon obtaining the information, one email is attached with the analytics, which notifies the user and manager in CC.
10/08/2024 10:20 AM
Please share report & email template configurations screenshot and query in text format