Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Cannot fetch application name in email

Kaustubh
Regular Contributor
Regular Contributor

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.

Kaustubh Pawar
Saviynt Certified IGA Professional
6 REPLIES 6

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

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

  • 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:

Kaustubh_0-1722831253158.png

 

Kaustubh_1-1722831270959.png

 

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

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


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

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:

Kaustubh_0-1722832932638.png

 

Kaustubh Pawar
Saviynt Certified IGA Professional

It should be USERNAME not username


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Raghu
All-Star
All-Star

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

 

 

 

 


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