Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/23/2024 02:34 PM
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;
10/23/2024 03:26 PM
Share report configuration screenshot. Does days are configured in global configuration
10/23/2024 03:55 PM
10/23/2024 04:30 PM
Email is sent so what is issue ?
10/23/2024 05:04 PM
10/23/2024 05:47 PM
Do you means entitlements are sending ?