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

SOD violation email notification to SOD risk owner

reshma_sonawane
New Contributor III
New Contributor III

Hi team,

We have a requirement where we want to have analytics which list users having SOD violations. This shall send email to SOD owner to take necessary action. What binding variable we can use to send email to sod owner?

Thanks,

Reshma

8 REPLIES 8

rushikeshvartak
All-Star
All-Star

Your query should have username column which will be username of sod owner & in email template to TO use ${userEmail}

Example 3: Email to inform control owner that account password is about to expire.

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

To: ${userEmail}

CC: ${ownerEmail}

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}

Refer https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter06-EIC-Configurations/Creati...



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

The query has column username of users having violation. In this case, how to include sod owner user name as well? will alias work?

Hi

I created analytics with below query. With this, I am able to send email to sod owner but email does not have report attachment. any idea on it?

Analytics query

SELECT u.username as SODUsername,u1.username, u.departmentname as 'Department', u.title, sr.Riskcode, rk.DESCRIPTION, CASE WHEN sr.status = 1 THEN 'NEW' END AS 'SoD Risk Status' FROM sodrisks sr,risks rk,riskowners ro,Users u, users u1 where sr.riskkey = rk.riskid and sr.userkey = u.userkey and sr.riskkey=ro.riskid and ro.owneruserkey=u1.userkey and sr.status =1 group by u.username,sr.Riskcode;

 

Please enable

Where do you want to save your data?

 
Send Email As Attachment
Save Data

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

Hi,

Yes these are enabled.

reshma_sonawane_0-1704703000502.png

In logs, it shows below. Query output has 10 records.

reshma_sonawane_1-1704703521604.png

 

Please select context and is this run time or normal report


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

With context, will it send email to individual user?

I am using normal report.

I tried putting owner in the analytics but with that it sent whole report to one user from the query and other email cam without attachment.

Context - will show only particular user there own data from UI. 

For report to individual owner it should work with userName in resultset of query 

Refer https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter06-EIC-Configurations/Creati...


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