How do I use a services user list to send a notification to all of them?

[Bidduam]

So what I want to do is I thought somewhat simple and it might be, but not for me currently lol

I have a list of services, each service has a bunch of users associated with each one. What I want to be able to do is to send an email notification to the list of users for whichever service has been selected.

I have a catalog item with a reference field called u_service which is using the cmdb_ci_service table. I want the notification to send at a point in the flow to all users associated with the selected service.

This is what I mean by users associated:

Anyone able to help me please, with actual instructions for my exact situation - I've looked at different forum chats already and found a heap, none of them are exactly what I want to do and I can't adapt them to do what I need either.

Thanks in advance.

[Tai Vu · Accepted solution]

Hi @Bidduam 

My above approach is for scripting part. You can refer to below for flow designer in your scenario.

1. Firstly, there should be a step to get catalog variable.

2. Then come to the Fire Event step.

Script

var service = fd_data._1__get_catalog_variables.u_service_affected; //call your variable from the 1st step
var users = [];
var gr = new GlideRecord('m2m_sp_status_subscription'); //your relationship table
gr.addQuery('cmdb_ci_service', service);
gr.query();
while(gr.next()){
	users.push(gr.getValue('sys_user'));
}
return users;

Cheers,

Tai Vu

[Dr Atul G- LNG]

Hi @Bidduam 

Give a try to Targeted communication module of ServiceNow.