Add Inbound Email CC users/Groups members to WatchList of Incident

satya9999
Tera Expert

You have to Create an Inbound Email Action as per Clients requirements and need to write following Script to identify users or Group members from Group mail id mentioned in CC.

//Fetch Users

var arr = [];
    var id = email.copied.split(',');
    for (var i = 0; i < id.length; i++) {
        var gr = new GlideRecord('sys_user');
        gr.addQuery('email', id[i]);
        gr.query();
        while (gr.next()) {
            arr.push(gr.sys_id.toString());
        }
    }

    //For group mail validation
    var grpArr = [];
    for (var val = 0; val < id.length; val++) {
        var grpObj = new GlideRecord('sys_user_group');
        grpObj.addQuery('email', id[val]);
        grpObj.query();
        while (grpObj.next()) {
            //if found match then extract the user
            var memberObj = new GlideRecord('sys_user_grmember');
             memberObj.addEncodedQuery('group.sys_id='+grpObj.sys_id);
            memberObj.query();
            while (memberObj.next()) {
                gs.log('User Fetched---------------->'+memberObj.user.name);
                var userObj = new GlideRecord('sys_user');
                userObj.addQuery('sys_id', memberObj.user.sys_id);
                userObj.query();
                while (userObj.next()) {
                    arr.push(userObj.sys_id.toString());
                }
            } //Grmember while end
        } //sys_user_group while end
    }
    current.watch_list = arr.toString();
 
 
in the attachment you can check if i add in CC a group called Change Management group mail id , it will add members of that group to watch list.
 
#Servicenow #Inbound #Email #Notifications
2 REPLIES 2

Brian Lancaster
Tera Sage

I don't understand, is there a question here?

i just got a requirement that is how to add inbound Email CC users/Groups members into incident watch list & its working fine ???? is there any better approach to achieve it????