Access request Expired notification

[Mukul]

Hello All,

We have a requirement to send an email when the access reaches its end date. This is the end date user selected while raising a request.

To get this working we created a job ("Create Tasks for Future Ent Role Requests") in the in the end point we added an email template on Revoke access. This is fine and works however, during UAR and it will still send the emails which we dont want.

Question : Is there another way to send email to the user when the requested entitlement is "Expired"?

Thanks

-Mukul

[rushikeshvartak]

You can send from analytics report.

OOTB Report - Entitlement Expiry Notification

[Mukul]

Hi Rushikesh,

Entitlement Expiry Notification sends the reminder notification numberof Days prior to the expiry of the access. We want to send the email after the entitlement is expired

Thanks

-Mukul

[rushikeshvartak]

You can update query and send notifications 

[Mukul]

yeah....but once entitlement is expired, its gone from the profile

[rushikeshvartak]

You can query on arstasks table where you can query on enddate column

[rushikeshvartak]

@Mukul 

select ev.entitlement_Value,a.startdate ,a.enddate from arstasks a,entitlement_values ev where a.enddate is not null and a.ENTITLEMENT_VALUEKEY=ev.entitlement_valuekey