We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Email notification for password expiration

Ekata
New Contributor III
New Contributor III

Hi Team,

We have a requirement to send multiple email notification to an user for password expiration but the users have orphan accounts. The privilege accounts are having different account name which is not synced with the actual user profile. And also there is no password policy set up by client. 

Can we create an analytic query to trigger the email using account's other attribute CP having email address value?

Or is there any other way to do so.

My system version is v2020.1.2

Regards,

Ekata Bharati

11 REPLIES 11

sahajranajee
Saviynt Employee
Saviynt Employee

Hi @Ekata ,

Are you trying to manage user password expiry or account password expiry?


Regards,
Sahaj Ranajee
Sr. Product Specialist

Ekata
New Contributor III
New Contributor III

Hi Sahaj,

I am trying for AD account password expiry.

Regards,

Ekata 

Ekata
New Contributor III
New Contributor III

Required to send the notification 

sahajranajee
Saviynt Employee
Saviynt Employee

You should be able to write analytics query to get the data in and send out email notifications to alert this.

 


Regards,
Sahaj Ranajee
Sr. Product Specialist

Ekata
New Contributor III
New Contributor III

Do we have any reference to do it as it an orphan account so not sure how we can attach the email address

Query

SELECT a.name 'Account Name', e.displayname 'Application Name', CASE WHEN a.status = 1 THEN 'Active' ELSE a.status END AS 'AccountStatus', e.endpointKey, a.customproperty1 as EMAIL, a.ACCOUNTTYPE FROM accounts a INNER JOIN endpoints e ON a.endpointKey = e.endpointKey AND a.status IN (1 , 'Active', 'Manually Provisioned') LEFT JOIN user_accounts ua ON ua.accountkey = a.accountkey WHERE ua.USERKEY IS NULL and datediff(date_add(a.LASTPASSWORDCHANGE, interval 30 day),sysdate()) between 0 and 10;

30 - expireafter

10 - DAYSTONOTIFBEFOREPWDEXPIREY

 

  • Create analytics report with EMAIL column in it  and this is case sensitive so only EMAIL will work.

You receive a single email with the details of all the accounts and the applications to which those belong.

To: ${ANALYTICSDATA.'EMAIL'[0]}

CC: 

Subject: Your password is about to expire

Body: ${ANALYTICSDATA.'First Name'[0]} ${ANALYTICSDATA.'Last Name'[0]},

The password for the following accounts is going to expire soon.

<table>

<tr><th>Application</th><th>Account name</th><th>Password expiry date</th></tr>

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

<tr><td>${ANALYTICSDATA.'Application'[i]}</td><td>${ANALYTICSDATA.'Account Name'[i]}</td><td>${ANALYTICSDATA.'Password Expiration Date'[i]}</td></tr><%}%>

</table>

Analytics name: ${analyticsConfig.analyticsName}

Analytics category: ${analyticsConfig.category}

https://saviynt.freshdesk.com/support/solutions/articles/43000622153-managing-email-templates 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Hi,

Thanks for the reply. The query is getting executed successfully but the email is not getting triggered. When I tried with my Email ID it is working fine but the ${ANALYTICSDATA.'EMAIL'[0]} is not working.

Do we have any other way to trigger it or do we need to add some data in configuration file?

Regards,

Ekata 

What is error you are getting. Maybe Analyticsdata is not exposed in TO else we need to write for loop


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

2022-07-18 10:04:59,922 [https-jsse-nio-443-exec-68] DEBUG analytics.AnalyticsESService - emailTemplate associated to control - Email notification for Password Expiration-Test
2022-07-18 10:04:59,922 [https-jsse-nio-443-exec-68] DEBUG services.SaviyntCommonUtilityService - Start bindBaseUrlEmailTemplate
2022-07-18 10:04:59,922 [https-jsse-nio-443-exec-68] DEBUG services.SaviyntCommonUtilityService - baseUrlForEmail value in externalConfig : [:]
2022-07-18 10:04:59,922 [https-jsse-nio-443-exec-68] DEBUG services.SaviyntCommonUtilityService - baseUrlForEmail is missing in the externalConfig file. Please add it !
2022-07-18 10:04:59,975 [https-jsse-nio-443-exec-68] DEBUG analytics.AnalyticsESService - to field in email template - T-Ekata.Bharti@bain.com, ${ANALYTICSDATA.'EMAIL'[0]}
2022-07-18 10:04:59,975 [https-jsse-nio-443-exec-68] DEBUG analytics.AnalyticsESService - tofield after removing useremail - T-Ekata.Bharti@bain.com, ${ANALYTICSDATA.'EMAIL'[0]}
2022-07-18 10:04:59,992 [https-jsse-nio-443-exec-68] DEBUG analytics.AnalyticsESService - groovy.lang.MissingPropertyException: No such property: ANALYTICSDATA for class: SimpleTemplateScript958

This is the error I found in Logs

${ANALYTICSDATAMAP.get("EMAIL")}

https://saviynt.freshdesk.com/support/solutions/articles/43000622153-managing-email-templates

Example 5


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

same error. Do we need to add something in configuration file?

I tried with ${accountemail} or ${accountcustomproperty20} Also but same error or all.

Note: CP20 has email value