How to fetch start date and end date of temporary access in email.

[LauleshaNigade]

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.]

[rushikeshvartak]

• ${task?.startdate}
• ${task?.enddate}

[LauleshaNigade]

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.

[rushikeshvartak · Accepted solution]

${entitlementshtmltablerowsv3}

[LauleshaNigade]

Hi @rushikeshvartak ,

The ${entitlementshtmltablerowsv3} variable is working in emails to fetch the start date and end date of the access, but we also want these values to appear in the SNOW ticket. We have tried using ${entitlementshtmltablerowsv3} in JSON, but it didn't work. Is there a specific syntax to fetch the start date and end date values in the SNOW ticket JSON?

Please let us know how can we achieve this goal.

Thank You.

[yatishtiwari]

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.

[rushikeshvartak]

Above variable is only used in email template. If any other requirement raise new thread