Cannot fetch application name in email

[Kaustubh]

Hi,

There is user manager campaign running for Access Verification Only.

We are sending the report of campaign using run time analytics to a person via email. We have a requirement where we want to send some details in email like 

Sub: Campaign report for <Application name>

Body:

Total Access:

Certified:

No Response:

Revoked:

Attached the report query.

Query is giving expected output but cannot map Application name and other details in email.

I get error as:

groovy.lang.MissingPropertyException: No such property: ANALYTICSDATA for class: SimpleTemplateScript106104 at SimpleTemplateScript106104.run(SimpleTemplateScript106104.groovy:8) at com.saviynt.ecm.analytics.AnalyticsESService.notifyEmailToOwner(AnalyticsESService.groovy:2663) at com.saviynt.ecm.analytics.AnalyticsESService.emailAction(AnalyticsESService.groovy:16541) at com.saviynt.ecm.analytics.AnalyticsESService.doFileArchivalAndSendEmail(AnalyticsESService.groovy:14717) at com.saviynt.ecm.analytics.AnalyticsESService$_runControl_closure210_closure318.doCall(AnalyticsESService.groovy:14550) at com.saviynt.ecm.analytics.AnalyticsESService$_runControl_closure210.doCall(AnalyticsESService.groovy:14549) at java.lang.Thread.run(Thread.java:750)

I have referred a post Solved: Print the content of the analytics in the email bo... - Saviynt Forums - 85171 but still getting error.

[rushikeshvartak]

• Share Report and Email configuration
• Does report contains column "username"
• Email To should be ${userEmail}

[Kaustubh]

• Share Report and Email configuration

Advanced HTML: True

To: ${userEmail}

CC: <personal email>

Sub: ACCESS CERTIFICATION ${ANALYTICSDATA.APPLICATION} AUDIT Report

Body:

<table>
<tr>
<th>
APPLICATION
</th>
</tr>
<%int count=Integer.parseInt( "${ANALYTICSDATA.APPLICATION.size()}");for(int i=0;i<count;i=i+1){%>
<tr><td>
${ANALYTICSDATAMAP.'APPLICATION'[i]}
</td>
</tr><%}%>
</table>

Report configuration:

• Does report contains column "username":  The query has SELECT 'admin' as username but I have not set it to be visible in the report.

[rushikeshvartak]

that should be fine. Your report should be static and not dynamic . Your report needs input as campaign name that should be static

[Kaustubh]

I changed the query and hard coded campaign name in where condition.

Tried SELECT 'admin' as username / SELECT 'admin' as 'username'

Still getting error below:

[rushikeshvartak]

It should be USERNAME not username

[Raghu]

@Kaustubh  yes it should be username dont pass alias name

example:

SELECT u1.username, 'admin' as 'username1' from users u1

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