Get User ID from sys_user_grmember

[shiva_gupta]

How to the user id and group name of all the user name   and group name listed in sys_user_grmember table using background script inside a variable or just   print those details .

[nishailame]

Try This

var gr = new GlideRecord("sys_user_grmember");

gr.query();

while(gr.next()){

        gs.print("User name : " + gr.getElement('user.user_name') + " Group name : "     + gr.getElement('group.name'));

}

[shiva_gupta]

yes got the exact output

thanks again

[sachin_namjoshi]

Please use below code which prints user id, user name and group

var sgp = new GlideRecord("sys_user_grmember");

sgp.addQuery('sys_id',"287f3358a9fe19810109062e982279cf");   // modify query as per requirements

sgp.query();

while(sgp.next()){

gs.print("User name is " +sgp.getDisplayValue('user'));

gs.print("User ID is " +sgp.getDisplayValue('user.user_name'));

gs.print("Group name is " + sgp.getDisplayValue('group'));

}

[shiva_gupta]

thanks

100% working

[muneermajeed]

var gr = new GlideRecord('sys_user_grmember');

// gr.addQuery('sys_id', 'd23bbe79ac1464186694751286d85f70');

gr.addQuery('user.name','Beth Anglin');

gr.query();

gs.info(gr.getRowCount());

while (gr.next()) {

    // gs.info(gr.group.name);

    var group = gr.group.name;

    var grmem = new GlideRecord('sys_user_grmember');

    grmem.addQuery('group.name',group);

    grmem.query();

    gs.info('\n\n');

    gs.info(group);

    gs.info(' --- Groups Members ------');

    while(grmem.next())

    {

        gs.info(grmem.user.name);

    }

}