Send email to users who did not login to ServiceNow for more than 60 days, then followed by reminder

[JuniorDev82]

My scenario is i want to send email to users who do not logged in to ServiceNow for over 60days with specific groups, then send 2nd reminder email if they still do not login after the 1st email is sent. 

I'm using flow designer. For the 1st email draft, I have started my flow by lookup for records which meets the condition of user is active & last login 60 days ago and group is "XXX". This is working and send emails to all users based on these conditions. However how do i proceed to send 2nd reminder email 7 days after the 1st email was sent if users still do not login to the servicenow? 

[Sainath N]

@JuniorDev82 : I would think of this approach.

1. After sending emails, at the end, call subflow (input: an array of user objects or sys IDs - This list can be obtained from your lookup of records).

2. In subflow, the first step is "wait for duration," then for each user object again, check the logged-in timestamp, and if it's > 60 days, send the reminder email.

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

[AnveshKumar M · Accepted solution]

Hi @JuniorDev82 

You can do this in 2 ways.

Option 1: In the same flow after the send email action, use a wait for condition (condition checking if the user logged in) action with time out of 7 days, and if the condition becomes true, you can end the flow otherwise send the 2nd reminder.

Option 2: Have another flow which checks if the user not logged in for 67 days then send an email.

Please mark my answer helpful and accept as a solution if it helped 👍✅

[JuniorDev82]

I applied option 2. I created 2nd flow with wait condition 7 days after the 1st email is sent. Thank you for your help! 

[Amit Verma]

Hi @JuniorDev82 

We can even make a scheduled job do this task for you. Please refer to below post and see if it helps.

https://www.servicenow.com/community/itsm-forum/how-to-send-reminder-mail/m-p/790109

Thanks & Regards

Amit Verma