
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2024 09:12 PM
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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2024 09:18 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2024 12:10 AM
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
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.