Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/09/2024 05:47 AM - last edited on 07/09/2024 07:37 AM by Dave
Hello,
We need to retrieve the start and end dates of temporary access entitlements for a disconnected application. We will send an email to the manager that includes these start and end dates. Additionally, we will send an email to the ABC team after creating the pending task, and this email notification will also include the start and end dates.
We have used the below query to check the values which we want to end in the mail.
select REQUEST_ACCESSKEY ,STARTDATE,ENDDATE,STATUS,COMMENTS,ACCESSTYPE,ACCESSKEY FROM request_access where REQUESTKEY =823
Output of query
In the below screenshot request_access is not exposed an a variable in mail.
Please let us know how can we achieve this goal.
Thank You.
[This post has been edited by a Moderator to remove sensitive information.]
Solved! Go to Solution.
07/09/2024 10:52 PM
07/10/2024 12:24 AM
The task start date will be the same as the entitlement's access start date because the pending task will be created on that date. However, the entitlement's access end date (the date when the remove access pending task will be created) can be different, as we select it dynamically while adding the access request timeframe, as shown in the image below.
Thank You.
07/10/2024 12:28 AM
${entitlementshtmltablerowsv3}
08/09/2024 04:27 AM
Please let us know how can we achieve this goal.
Thank You.
08/09/2024 05:14 AM
Hi @rushikeshvartak ,
We found out that the value is in REQUEST_ACCESS table.
We tried to use ${requestAccess} and ${requestAccessAttributes} variables.
But looks like ${requestAccess} is not exposed and ${requestAccessAttributes} is a map which has some limited attributes exposed. Exposed attributes are-
[ACCOUNTNAME:eenduser11, ENDPOINT:11, REQUESTORIGIN:ECMV6]
Is there any way to fetch the desired attributes?
Thanks in Advance.
08/09/2024 05:51 AM
Above variable is only used in email template. If any other requirement raise new thread