Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/17/2024 02:44 AM
Hi,
How to pass the Endpoint name which is captured in analytics report in the subject of the email template.
Thanks,
04/17/2024 02:58 AM - edited 04/17/2024 03:01 AM
SQL Query :
Select AccountName,
(select username from users where userkey = ars.userkey) as username,
(select concat(firstname,' ',lastname) from users where userkey = ars.userkey) as 'Requestee Name',
(select endpointname from endpoints where endpointkey =1)
as ENDPOINT,
COMMENTS as 'Task comments',
PROVISIONINGTRIES as 'Provisioning tries',
PROVISIONINGCOMMENTS
from
arstasks ars
where PROVISIONINGCOMMENTS like '%Error%' and ars.securitysystem = 10.
Sample HTML and want subject use like ${ANALYTICSDATA.'ENDPOINT'[0]}
Hi ${requestedBy.username},
This email is sent to notify you that the ${ANALYTICSDATA.'ENDPOINT'[0]} request for ${requestedBy.username} is unsucessful.
Error Log: ${ANALYTICSDATA.'PROVISIONINGCOMMENS'[0]}
Reference : https://forums.saviynt.com/t5/identity-governance/analyticsdata-and-analyticsdatamap-are-not-working...
04/17/2024 06:09 PM
Can you share report configuration and query