Send notification if account expiry in 30 days

Bidduam
Tera Guru

On our user profile we added some time ago a field called "u_account_expiry".

What I need to do is send an email notification to the user and their manager if the users account expiry will occur within the next 30 days.

 

How would I go about getting the 'list of users' that fit into that category to add as the recipient in a notification?

 

I figured I could do it in a flow or a scheduled job, but either way I don't know how to generate the list of users and their managers.

1 ACCEPTED SOLUTION

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

You could create a daily Scheduled Flow, query through all the users where u_account_expiry is 30 days from now, and create a notification to that user and their manager.

 

Give it a try.

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

View solution in original post

5 REPLIES 5

Amit Verma
Kilo Patron
Kilo Patron

Hi @Bidduam 

 

Below posts could be helpful to setup the flow :

https://www.servicenow.com/community/itsm-forum/report-on-account-expire-in-30-days/m-p/663886

https://www.servicenow.com/community/itsm-forum/sent-notification-30-and-14-days-before-the-expiry-d...

 

If you want to do this via Scheduled Job, refer https://www.servicenow.com/community/service-management-forum/email-notification-that-account-is-get...

 

Thanks and Regards

Amit Verma


Please mark this response as correct and helpful if it assisted you with your question.