Analytics Email template with Endpoint name

[Saviyntreh]

Hi, 

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

Thanks,

[Raghu]

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

[rushikeshvartak]

Can you share report configuration and query