Click HERE to see how Saviynt Intelligence is transforming the industry.
|
Click HERE to see how Saviynt Intelligence is transforming the industry.
|
Hi All,
We have created email notification for entitlement and role expiry (2 different report and email template) and we email notification is getting generated but role we are seeing error in logs. Below is the report, email template and log for reference.
email template
To- ${userEmail}
Body
<!DOCTYPE html>
<html>
<head>
<style>
table {
font-family: arial, sans-serif;
border-collapse: collapse;
width: 100%;
}
td, th {
border: 1px solid #dddddd;
text-align: left;
padding: 8px;
}
tr:nth-child(even) {
background-color: #dddddd;
}
</style>
</head>
<body>
Hi ${ANALYTICSDATA.firstname[0]} ${ANALYTICSDATA.lastname[0]},<br><br>
Some of your assigned Roles are going to expire soon. Please find the details below:<br><br>
<table>
<tr>
<th>Username</th>
<th>Account Name</th>
<th>RoleName</th>
<th>Description</th>
<th>Role End Date</th>
</tr>
<% int count=Integer.parseInt("${ANALYTICSDATA.Application.size()}"); for(int i=0;i<count;i=i+1){%>
<tr>
<td>${ANALYTICSDATA.username[i]}</td>
<td>${ANALYTICSDATA.'Account Name'[i]}</td>
<td>${ANALYTICSDATA.Role Name[i]}</td>
<td>${ANALYTICSDATA.Description[i]}</td>
<td>${ANALYTICSDATA.'Role End Date'[i]}</td>
</tr>
<% } %>
</table><br><br>
Regards,<br>
MYITAccess Admin Team<br>
</body>
</html>
Analytics
select u.username, u.firstname, u.lastname, a.name as 'Account Name',r.role_name as 'Role Name', r.description as 'Description', rua.enddate as 'Role End Date'
from users u, roles r, role_user_account rua, accounts a
where u.USERKEY=rua.USERKEY
and r.ROLEKEY=rua.ROLEKEY
and a.ACCOUNTKEY=rua.ACCOUNTKEY
and rua.ENDDATE is not null
and r.STATUS=1
and u.STATUSKEY=1
and a.STATUS in ('1','Active','Manually Provisioned')
and DATEDIFF(rua.ENDDATE,sysdate()) between 0 AND (select configdata from configuration where name = 'NUMBEROFDAYSBEFOREROLEEXPIRYDATE')
order by username;
