Saviynt Forums

Padmavathi · ‎04/12/2024

Hi Team,

we have requirement of sending email notification with analytic report generated time.

We are unable to receive any email notifications with the below paramenters.

1. ${date}

2. ${ANALYTICSDATA.'START DATE'[i]}

3. ${ANALYTICSDATAMAP.get("START DATE")}

Can anyone help us to resolve the issue.

Thanks,

Padmavathi

Raghu · ‎04/12/2024

use it like below , don't use direct 'Date' key field in your query it wont be support change like

${ANALYTICSDATA.'StartDatee'}

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

Padmavathi · ‎04/12/2024

Hi @Raghu

Thanks for the reply!

I have configured the email notification to the analytical report.

my email notification is like below:

This I have used as your reply

<html> <body> ${ANALYTICSDATA.'StartDatee'} </body> </html>

next run I changed to below.

<html> <body> ${ANALYTICSDATA.'StartDate'} </body> </html>

To: ${userEmail}

CC: my email address is used here.

I am still not receiving the email.

Please let me know, if i missed anything.

Thanks in advance!

Padmavathi.

Raghu · ‎04/12/2024

can you share analytic query please :

reference getting notify mail via report:

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.

Padmavathi · ‎04/12/2024

Hi @Raghu

I am just using sample query like below for testing the notification.

select statuskey from users where userkey = 1

Thank you!

Padmavathi

Raghu · ‎04/12/2024

use below

select u.username,u.statuskey as 'states' from users u where u.userkey = 1

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

Raghu · ‎04/12/2024

temple use it below for sammple

Hello, Please find the Analytics Report for Cloud Groups which doesn't have Description. This email is sent from Saviynt PROD Instance. PLEASE DO NOT REPLY TO THIS EMAIL. - Saviynt Security Manager

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

Padmavathi · ‎04/12/2024

Hi @Raghu

I have used the query as you suggested, now the email came but with null value like below.

[null]

Thanks,

Padmavathi.

Raghu · ‎04/12/2024

@Padmavathi it is expected , dont have any analyticData right it will come null, if u want sample use it above format

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

Padmavathi · ‎04/12/2024

Hi @Raghu

I have placed the query that is having data, even though it is giving [null].

Thanks,

Padmavathi

Raghu · ‎04/12/2024

can you share query and html

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

Padmavathi · ‎04/12/2024

Hi @Raghu

Please find the email template:

used two diff queries to test the email notification:

1. select u.username from users u where u.firstname = 'abc'

2. select t1.username from users t1, users t2 where
((t1.firstname = t2.firstname) OR (t1.lastname = t2.lastname) OR (t1.phonenumber = t2.phonenumber)) AND
(t1.USERKEY <> t2.USERKEY) AND (t1.STATUSKEY=1) AND (t2.STATUSKEY=1) AND t1.userkey < 15

I am able to see the data but email templates is returning [null]

Can you please let me know, if i missed anything.

Thanks,

Padmavathi

rushikeshvartak · ‎04/12/2024

Report Alert - ${analyticsConfig.displayName} - ${Calendar.getInstance().getTime().format('yyyy-MM-dd hh:mm')}

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

Raghu · ‎04/13/2024

Query sample : Username should be include as per document if dont want also.

select u.username,u.startdate as 'startDtee' from users u where u.createdate <= DATE_SUB(CURDATE(), INTERVAL 10 DAY) and u.userkey = 1

Html : Below syntax of alias name

Hello, Please find the Analytics Report for Cloud Groups which doesn't have Description. This email is sent from Saviynt PROD Instance. PLEASE DO NOT REPLY TO THIS EMAIL. - Saviynt Security Manager ${ANALYTICSDATA.'startDtee'[0]}

it is working for me , your syantx issue check AnalyticDate object in templte

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

Padmavathi · ‎04/15/2024

Hi @Raghu @rushikeshvartak

Thanks for the response!

Our requirement is to get the date that report generated from the analytics.

I am unable to get name of the analytics but able to get the date with @rushikeshvartak suggestion.

${Calendar.getInstance().getTime().format('yyyy-MM-dd hh:mm')}

I will try this and update ${ANALYTICSDATA.'startDtee'[0]}

Thanks,

Padmavathi.

rushikeshvartak · ‎04/15/2024

it seems you dont have display name for analytic

Report Alert - ${analyticsConfig.displayName!=null && analyticsConfig.displayName!="" ? analyticsConfig.displayName : analyticsConfig.analyticsName } - ${Calendar.getInstance().getTime().format('yyyy-MM-dd hh:mm')}

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

Padmavathi · ‎04/17/2024

Hi @rushikeshvartak

yeah, Displayname is missing in the Report. Thank you!

Regards,

Padmavathi

Padmavathi · ‎04/15/2024

Hi @rushikeshvartak

We have provided the display name in the analytical. But, let me check the above suggestion and get back to you.

Thanks,

Padmavathi

Saviynt Forums

Analytic Report Generation Date