Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Analytics Email template with Endpoint name

Saviyntreh
New Contributor III
New Contributor III

Hi, 

How to pass the Endpoint name which is captured in analytics report in the subject of the email template.

Thanks,

2 REPLIES 2

Raghu
All-Star
All-Star

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...

 


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

rushikeshvartak
All-Star
All-Star

Can you share report configuration and query


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.