Script to add cc'd users to watch list

[mkader]

Hello,

I need to create an inbound action that auto populates the watch list with  cc'd user(s) for RITMs. How can I do this? If a cc'd user does not exist in the system, I do not want to create a new user

Thanks!

[Ankur Bawiskar]

@mkader 

Sample script for help

var ccUsers = email.copied;

var arr = [];

var rec = new GlideRecord('sys_user');
rec.addQuery('email', 'IN', ccUsers);
rec.query();
while(rec.next()){
arr.push(rec.getValue('sys_id'));
}

var existingWatchList = current.watch_list.toString().split(',');

var arrayUtil = new ArrayUtil();

var finalArr = arrayUtil.concat(existingWatchList,arr);

finalArr = arrayUtil.unique(finalArr);

current.watch_list = finalArr.toString();

current.update();

Regards
Ankur

[mkader]

@Ankur Bawiskar - Thank you for your response. I've tried this, and It does not seem to be triggering. I will set it up in my PDI and test again. Below screenshots is what I have done:

What is the best way to test this?

[asifnoor]

Hi,

Try like this.

var ccUsers = email.copied;
ccUsers = ccUsers.toString().split(",");
var users = [];
for(i=0;i<ccUsers.length;i++) {
  useres.push(ccUsers[i]);
}


var rec = new GlideRecord('sys_user');
rec.addQuery('email', 'IN', users);
rec.query();
while(rec.next()){
arr.push(rec.getValue('sys_id'));
}
gs.log("CC users in SN are "+arr);

var existingWatchList = current.watch_list.toString().split(',');

var arrayUtil = new ArrayUtil();

var finalArr = arrayUtil.concat(existingWatchList,arr);

finalArr = arrayUtil.unique(finalArr);

current.watch_list = finalArr.toString();

current.update();

[Ankur Bawiskar]

@mkader 

send an email to the instance and keep some email address in cc.

remember to keep around 5 users in cc and out of those 5 only 3 should be present in ServiceNow.

Only 1 inbound email action would be processed for a table.

So keep the order as 10 and select the checkbox of Stop processing.

Regards
Ankur

[mkader]

I tried this in my PDI and was not able to make this work:

(function runAction( /*GlideRecord*/ current, /*GlideRecord*/ event, /*EmailWrapper*/ email, /*ScopedEmailLogger*/ logger, /*EmailClassifier*/ classifier) {

    var ccUsers = email.copied;
    ccUsers = ccUsers.toString().split(",");
    var users = [];
    for (i = 0; i < ccUsers.length; i++) {
        useres.push(ccUsers[i]);
    }


    var rec = new GlideRecord('sys_user');
    rec.addQuery('email', 'IN', users);
    rec.query();
    while (rec.next()) {
        arr.push(rec.getValue('sys_id'));
    }
    gs.log("CC users in SN are " + arr);

    var existingWatchList = current.watch_list.toString().split(',');

    var arrayUtil = new ArrayUtil();

    var finalArr = arrayUtil.concat(existingWatchList, arr);

    finalArr = arrayUtil.unique(finalArr);

    current.watch_list = finalArr.toString();

    current.update();

})(current, event, email, logger, classifier);