The CreatorCon Call for Content is officially open! Get started here.

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.