Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/09/2024 03:44 AM
Hi team,
We have a requirement to send email notification to provisioning owners of disconnected applications upon remove access or remove account task creation through certification. Is there any binding variable available to fetch task owner details in the 'Revoke Task Email Template' of Campiagn module ?
We observed that when task source is CERTIFICATION, Saviynt doesn't send email template configured at the endpoint level. It only tries to send the email configured in the campaign.
Solved! Go to Solution.
10/09/2024 04:44 AM
Hi @Akshatha ,
You can use analytics to send an email in that case. Through analytics even you can get the task owner details and populate in email as well.
10/09/2024 04:48 AM
You can also use ${this.binding.variables.each {k,v -> println "$k = $v" + "" + "br" + ">"}} to find what binding variables are supported
If this doesnt have the binding variable you are looking for then not supported
10/09/2024 05:50 AM
10/10/2024 05:09 AM
Hello Rushikesh,
What is the known issue ? Can you please elaborate ? Are you saying that we are unable to fetch task owner details in the 'Revoke Task Email Template' of Campiagn module ? I do have a support ticket open for this one.
Alternatively, I tried to fetch the task owner details from analytics.
This is the query I used:
select u.username, u.username AS uname, ars.taskkey, ars.taskdate, ars.endpoint, ars.securitysystem, ars.source, (select email from users where userkey=ars.ownerkey) owneremail, (select username from users where userkey =ars. requestedby) requestedby, (select entitlement_value from entitlement_values ev where ev.entitlement_valuekey = ars.entitlement_valuekey)entitlement_value from arstasks ars, users u where ars.tasktype in (2,8) and ars.endpoint in ('337') and ars.source in ('CERTIFICATION') and ars.ownerkey != '1' and ars.status ='2'and u.userkey=ars.userkey
I tried to list down the binding variables available from this analytics in the email template. Here is what I got:
date = 2024-10-10 12:01:16
endpoint = null
totalRecords = 1
analyticsConfig = com.saviynt.ecm.analytics.AnalyticsConfigES : 1844
endpointDisplayName = null
baseUrlForEmail = https://release-n-plus-one.saviyntcloud.com/ECM
ownerEmail =
out = java.io.PrintWriter@4ddc0f2c
test
[date:2024-10-10 12:01:16, endpoint:null, totalRecords:1, analyticsConfig:com.saviynt.ecm.analytics.AnalyticsConfigES : 1844, endpointDisplayName:null, baseUrlForEmail:https://release-n-plus-one.saviyntcloud.com/ECM, ownerEmail:, out:java.io.PrintWriter@4ddc0f2c]
Looks like it is not fetching any value for ownerEmail. Let me know if I am doing something wrong.
Thanks,
Akshatha Bhat
10/10/2024 05:19 AM
SELECT
owner.username as USERNAME,
u.username as 'USERUSERNAME',
u.username AS uname,
ars.taskkey,
ars.taskdate,
ars.endpoint,
ars.securitysystem,
ars.source,
owner.email AS owneremail,
requester.username AS requestedby,
ev.entitlement_value
FROM
arstasks ars
LEFT JOIN
users u ON u.userkey = ars.userkey
LEFT JOIN
users owner ON owner.userkey = ars.ownerkey
LEFT JOIN
users requester ON requester.userkey = ars.requestedby
LEFT JOIN
entitlement_values ev ON ev.entitlement_valuekey = ars.entitlement_valuekey
WHERE
ars.tasktype IN (2,8)
AND ars.endpoint = '337'
AND ars.source = 'CERTIFICATION'
AND ars.ownerkey != '1'
AND ars.status = '2';
In Email template to keep ${userEmail}
10/10/2024 09:44 AM
Thank you Rushikesh, With this query and the binding variable, I am able to fetch the required details.