Email not triggering through user update rule

[ruchika]

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;

[rushikeshvartak]

You can’t send report data using analytics. You need schedule report separately 

[ruchika]

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.

[rushikeshvartak]

Currently its not exposed. Upvote below idea https://ideas.saviynt.com/ideas/EIC-I-3859 

[ruchika]

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.

[pmahalle]

@ruchika 

Can you try ${manager.email} once and check.

[rushikeshvartak · Accepted solution]

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}

[NM]

Hi @ruchika , use analytics for above use case