ANALYTICS EMAIL VARIABLE

[alvian]

Hi All,

I've created the analytics query for the end-of-day provisioning error report:

Select

ars.taskkey,

u.username,

"AWS SSO" as 'endpointname',

"error" as 'provisioningstatus',

ars.provisioningcomments,

ars.updatedate AS 'taskdate'

from arstasks ars JOIN users u

ON u.userkey = ars.userkey

where ars.endpoint=99 and ars.updatedate >= CURDATE() and status !=3

and I've also created an email template for the analytics above:

Dear Cloud Admin,<br><br>

<b>Below is the list of provisioning task with error state from today:</b><br>

<table>
<tr>
<th>TAKS KEY</th>
<th>USERNAME</th>
<th>ENDPOINT NAME</th>
<th>PROVISIONING COMMENTS</th>
<th>PROVISIONING STATUS</th>
<th>TASK DATE</th>
</tr>
<% int count=Integer.parseInt("${ANALYTICSDATA.taskkey.size()}"); for(int i=0;i<count;i=i+1){%>

<tr>
<td>${ANALYTICSDATA.'taskkey'[i]}</td>
<td>${ANALYTICSDATA.'username'[i]}</td>
<td>${ANALYTICSDATA.'endpointname'[i]}</td>
<td>${ANALYTICSDATA.'provisioningcomments'[i]}</td>
<td>${ANALYTICSDATA.'provisioningstatus'[i]}</td>
<td>${ANALYTICSDATA.'taskdate'[i]}</td>
</tr>
<% } %>
</table>

<br>Attached is the detailed list of provisioning tasks with error states from today.<br>

<br>IDM Notification

But somehow the email didn't send to my email, even though the variables of analytics data are correct I guess and then I've set the recipient email to my email statically. Can anyone help?

[rushikeshvartak]

Please share report config screenshot and try below code in email body

To get what variables are present to use in the email template, check using the below expression. By putting it in the email body, it will print all variable names with values, and then accordingly, you can use it:


${this.binding.variables.each {k,v -> println "$k = $v" + "" + "br" + ">"}}

[alvian]

here is the report config screenshot

and here is the output if I try using that variable 

Thanks,
Alvian

[rushikeshvartak]

Report config and not output

[alvian]

this one 

Thanks,
Alvian

[rushikeshvartak]

Does global config - group by username is checked under analytics ?

• remove actions from report
• does report is not runtime ?
• report is clicked to save as ?

[alvian]

• remove actions from report = I've done it before but the result still no success
• does report is not runtime ? = what do you mean on it ? I just manually ran this report
• report is clicked to save as ? = Which button should I click to save the report? I've set it to "send email as attachment"
  

[rushikeshvartak]

• Save data.
• share screenshot from analytics config list for report ( if report end with symbol then its runtime)

[Raghu · Accepted solution]

@alvian  add in recipet

to :  ${userEmail}

cc : include your mail id  - try

[alvian]

@Raghu ,

oohh it was a mandatory yap, to set to :  ${userEmail}, after I set this, all the values ​​of the variables I called were in the body of the email... thinking there was something wrong with calling the variables.. Thanks a lot 

Regards,
Alvian

[Raghu]

Great , Thanks for info..!