Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/30/2024 10:21 AM
We need to trigger email to user manager once the user gets deactivated. We are doing a transfer ownership using user update rule and have added a email template in the action.
We need to send the email to user's manager with entitlement list(excel sheet).
How can this be achieved. We have also configured an analytics that sends the data, is there an option to trigger this via user update rule.
Below is analytics that we are using:
SELECT m.username,u.username as 'Entitlement_owner', u.displayname, u.employeeclass, u.departmentname as 'DEPARTMENT', CASE u.statuskey WHEN 1 THEN 'Active' WHEN 0 THEN 'Inactive' END AS 'USERSTATUS', ev.entitlement_value, et.entitlementname, ep.endpointname FROM users u INNER JOIN entitlement_owners eo ON u.userkey = eo.userkey INNER JOIN entitlement_values ev ON eo.entitlement_valuekey = ev.entitlement_valuekey INNER JOIN entitlement_types et ON ev.entitlementtypekey = et.entitlementtypekey INNER JOIN endpoints ep ON et.endpointKey = ep.endpointKey INNER JOIN users m ON u.manager=m.userkey WHERE u.statuskey = 0;
Solved! Go to Solution.
05/30/2024 12:43 PM
You can’t send report data using analytics. You need schedule report separately
05/31/2024 08:09 AM
Can we send a list of the entitlements transferred to the inactive user manager through user update rule in an email format.
Are there any binding variables available that we can use in email template configuration for the same.
06/03/2024 07:46 PM
Currently its not exposed. Upvote below idea https://ideas.saviynt.com/ideas/EIC-I-3859
06/04/2024 03:47 AM
Can you let me know how can we trigger an email to user's manager when the update rule triggers. I am trying with ${usersManager.email} in "To" section of email but it isn't sending an email to user's manager.
06/04/2024 04:48 AM
Can you try ${manager.email} once and check.
06/04/2024 05:11 AM
Below variable exposed on user update rules
entitlement_endpoint_list = []
manager = stest100
createdBy = admin
service_accounts_list = []
ownerOnTerminate = stest1001
serviceaccount_endpoints_list = []
baseUrlForEmail = https://-dev.saviyntcloud.com/
user = stest0098
requestor = 155390
entitlement_value_list = []
out = java.io.PrintWriter@
hence you can use ${manager?.email}
05/31/2024 11:13 PM
Hi @ruchika , use analytics for above use case