How to access Analytics Data in Email Template using variables?

[amanmalakar007]

Hi Saviynt family,

I need to refer back to, or 'access' certain values from the Analytics report data in my email template. I tried using ANALYTICSDATA.'USERNAME'[i] and ANALYTICSDATA.'firstname'[i] but they don't seem to work. 

Can someone suggest what I might be missing? Attaching the Email Template below.

Hi,
Please find data table below :
<table>
<tr><th>Username</th><th>First Name</th><th>Account End Date</th></tr>

<%int count=Integer.parseint(“${ANALYTICSDATA.Application.size()}”); for(int i=0;i<count;i=i+1){%>

<tr><td>${ANALYTICSDATA.'USERNAME'[i]}</td><td>${ANALYTICSDATA.'firstname'[i]}</td><td>${ANALYTICSDATA.'enddate'[i]}</td></tr><%}%>

</table>
Thank you!

[rushikeshvartak]

Your email To should be ${userEmail} and SQL query should have column alias as usename

Please share report and email template config screenshot if still facing issue after validating above 

[amanmalakar007]

Sure, please find the Analytics Query, Report config and Email Template below : 

Analytics Report Query:

Analytics Report Config:

Email Template:

[rushikeshvartak]

• There are 2 issues
• Report --> Alias should be exact username 
  • so change username1 to username
• Email
  • TO Should be only ${userEmail}
    • Remove your email or move to CC/BCC

[Raghu]

@amanmalakar007  please flow below article it will help u.

query  remove for username alias , want use other username

example :

select u.username,u.username as 'username1',u.email as 'email' from user u

https://forums.saviynt.com/t5/identity-governance/analyticsdata-and-analyticsdatamap-are-not-working...