Click HERE to see how Saviynt Intelligence is transforming the industry. |
03/28/2024 11:24 AM - edited 03/28/2024 11:28 AM
I have a situation where, when a user is given birthright access via enterprise roles to a disconnected application, I need a query to trigger email notification to admin or admin groups to execute tasks. Endpoint level email template only triggers when the task inside saviynt is marked complete, that is not ideal as we have to notify the admins to provision access first before marking the task complete. Can someone help with this query/analytics and process?
Solved! Go to Solution.
03/28/2024 07:34 PM
SELECT 'admin' AS username,
TASKKEY,
A.ACCOUNTNAME,
A.STATUS,
E.ENDPOINTNAME
FROM ARSTASKS A,
ENDPOINTS E
WHERE A.ENDPOINT = E.ENDPOINTKEY
AND A.STATUS = 1
AND A.OWNERTYPE = 2
04/04/2024 06:20 AM
is there a way to spit these results into the body of the email template? instead of going the analytics report route?
04/04/2024 10:43 AM
Currently No its not supported Please raise support/idea ticket
04/04/2024 06:30 AM
need to prepare query based analytics object print in email template , you will get results in email template
reference article :
04/04/2024 05:42 PM - edited 04/04/2024 08:15 PM
@Raghu thanks for the link to the post. Played around with it and it works.
04/04/2024 08:40 PM
Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.
04/04/2024 08:34 AM
@theosveg : We have similar requirement in our environment and noticed that Saviynt is not sending task creation endpoint level emails and opened a ticket support and we were told there is a known bug about this. Currently awaiting for confirmation and version in which it is fixed.
04/04/2024 10:12 AM - edited 04/04/2024 10:13 AM
this is great info, thank you @Saathvik. Kindly provide info when you receive an update.
04/05/2024 08:28 AM - edited 04/05/2024 08:30 AM
Approach I took to complete this exercise, thanks @Raghu for the other forum post link with a similar issue:
SELECT u.username, u.username as 'endpoint owner', A.TASKKEY as 'taskkey', A.ACCOUNTNAME as 'accountname', A.STATUS as 'taskstatus', E.ENDPOINTNAME as 'endpoint', A.OWNERTYPE, U.EMAIL FROM ARSTASKS A JOIN ENDPOINTS E ON A.ENDPOINT = E.ENDPOINTKEY JOIN USERS U ON E.OWNERKEY = U.USERKEY WHERE E.customproperty6= 'disconnected' AND A.STATUS = 1
order by username;
<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 Endpoint Owner,<br><br>
The following user(s) hav been assigned account/access to your disconnected application. Please find the details below:<br><br>
<table>
<tr><th>Endpoint Owner</th><th>Account Name</th><th>Endpoint</th><th>Task Key</th></tr>
<% int count=Integer.parseInt("${ANALYTICSDATA.Application.size()}"); for(int i=0;i<count;i=i+1){%><tr><td>${ANALYTICSDATA.'endpoint owner'[i]}</td><td>${ANALYTICSDATA.'accountname'[i]}</td><td>${ANALYTICSDATA.'endpoint'[i]}</td><td>${ANALYTICSDATA.'taskkey'[i]}</td></tr>
<% } %>
</table>
04/05/2024 09:20 AM
Great, thanks for info.