Background script - get users email_id's

[Ankita9793]

Hi All,

Can someone please help me with the below script, I'm trying to fetch 'email id' of 'delname' users.

var delname = 'Mohmed Ahm, Sudarsh Dhoni';

var delnew = delname.split(',');

for (var i = 0; i <= delnew.length; i++) {

    var getdel = new GlideRecord('sys_user');

    getdel.addQuery('name', delnew[i]);

    getdel.query();

    if (getdel.next()) {

        var delarray = [];

        delarray.push(getdel.email);

        var delemailid = delarray;

        gs.print('delemailid 1 ' + delemailid );

    }

}

gs.print('delemailid 2' + delemailid );

[Shruti]

var delname = 'Mohmed Ahm,Sudarsh Dhoni';
var delnew = delname.split(',');
var delarray = [];
for (var i = 0; i < delnew.length; i++) {
    var getdel = new GlideRecord('sys_user');
    getdel.addQuery('name', delnew[i]);
    getdel.query();
    if (getdel.next()) {
        
        delarray.push(getdel.email+'');
        var delemailid = delarray;
        gs.print('delemailid 1 ' + delemailid );
    }

}
gs.print('array' + delarray );

[Ankur Bawiskar]

@Ankita9793 

if the users are present in sys_user with exact name then try this and see if that works

var delname = 'Mohmed Ahm, Sudarsh Dhoni';
var delnew = delname.split(',');

var delarray = [];

for (var i = 0; i <= delnew.length; i++) {
    var getdel = new GlideRecord('sys_user');
    getdel.addQuery('name', delnew[i]);
    getdel.query();
    if (getdel.next()) {
        delarray.push(getdel.email.toString());
    }

}
gs.print('delemailid 2' + delarray.toString());

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Ankita9793 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Bhuvan]

@Ankita9793 

Try this,

var emailList = [];
var gr = new GlideRecord('sys_user');
gr.addEncodedQuery("name=Abel Tuter^ORname=Adam Ringle");
gr.query();
while (gr.next()) {
  emailList.push(gr.email.toString());
}
gs.print('Email List: ' + JSON.stringify(emailList));

 Below is sample execution,

Thanks,

Bhuvan