Send notification if account expiry in 30 days

dannyprime
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

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