create email notification for a inactive user of the group

[Shruthi1987]

Hi All,

It is first time to work on the wmail notification. I need to create an email notification the following conditions where the target groups are those that start with API..
1. When a ServiceNow Group member's account becomes inactive: Emails will be sent to the Group Manager and Group Member, with cc to the CMDB team
2. When a ServiceNow Group manager's account becomes inactive: Emails will be sent to the Group Member, with cc to the CMDB team

Can I create both the condition in one email notification or need to create separate notification?
Can it be done with email notification setting or should I use flow designer?

It will be helpful if anybody help me with script to send the notification for the above conditions? 

Thank you.

[Shruthi1987]

Hello @Sai_Charan_K ,

Thank you soo much for your prompt support. 

Could you please help me to know how can I send email to all the group members dynamically when there is no group email address ?

[Sai_Charan_K]

Hi @Shruthi1987 ,

In order to send email to individual group members along with group email, you can lookup group records for the groups which the user is manager and for each group member you can send the email. Please check the below screenshot for reference.

In step no. 5 in "To" field add the user's email from step no. 4 to send the emails to the group members along with the group mail.

Please mark my answer "Helpful" and "correct" if you feel that it has helped you in any way.

Thanks and Regards,
K. Sai Charan
Sr. ServiceNow Developer
Deloitte India

[PyLaRue]

I'm trying to achieve something similar to this but with "every group that start with Approbation"
I tried to duplicate your 4th step. 
table Sys_user_grmember
Name : Start with : Approbation
but I cant find your second condition "user" to put the 
user is "user - record" 

how did you do that? 

[Sai_Charan_K]

Hi @PyLaRue,

In step 1 of my flow you need to make changes by explicitly adding your group name filter which will allow you to find the no. of groups that are matching the conditions. Rest of the steps are as it is.

If it's still not working please send the whole flow which you have built to assess the issue and help you to resolve it.

Thanks and Regards,

K. Sai Charan

Sr. ServiceNow Developer

Deloitte India

[PyLaRue]

My bad i mean your step 6 were you lookup group member where group start with api and user is user record. 

I'm able to lookup group member and says "name" start with "approbation" but the "user is "user record" part I cant find "user as a criteria of sys_user_grmember. or did you used another table? 
could you expend that step and show it? 

thank you 🙂