Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners Click HERE | EMEA/APJ Click HERE |
01/06/2024 10:00 AM
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
01/06/2024 12:07 PM
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}
01/07/2024 12:36 AM
The query has column username of users having violation. In this case, how to include sod owner user name as well? will alias work?
01/07/2024 02:01 AM
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;
01/07/2024 08:18 AM
Please enable
Where do you want to save your data?
01/08/2024 12:45 AM
Hi,
Yes these are enabled.
In logs, it shows below. Query output has 10 records.
01/08/2024 11:29 AM
Please select context and is this run time or normal report
01/09/2024 11:00 PM
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.
01/10/2024 07:27 PM
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