Print the all users belong to Analyst Group

[Anusha Gorige]

Print the all users belong to Analyst Group

[Danish Bhairag2 · Accepted solution]

Hi @Anusha Gorige ,

Please try below script

var users = '';
var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('group','<sys_id_of_group>');
gr.query();
while(gr.next()){
    users += gr.user.getDisplayValue() + '\n';
}

gs.info(users);

Thanks,

Danish

[pratiksha5 · Accepted solution]

// Specify the name of the Analyst Group you want to retrieve members for
var analystGroupName = 'YourAnalystGroupName';

// Create a GlideRecord query to fetch members of the Analyst Group
var groupQuery = new GlideRecord('sys_user_grmember');
groupQuery.addQuery('group.name', analystGroupName);
groupQuery.query();

// Check if there are any members in the Analyst Group
if (groupQuery.getRowCount() > 0) {
// Loop through the members and print their details
while (groupQuery.next()) {
var memberId = groupQuery.getValue('user');

// Fetch user details using the user ID
var userQuery = new GlideRecord('sys_user');
if (userQuery.get(memberId)) {
var userName = userQuery.getValue('user_name');
var userEmail = userQuery.getValue('email');

// Print or process the user details as needed
gs.info('User Name: ' + userName + ', User Email: ' + userEmail);
}
}
} else {
gs.info('No members found in the Analyst Group: ' + analystGroupName);
}

[Sohail Khilji · Accepted solution]

Can you share more insite on what your trying to attain, Are your looking just for a script if yes...

var groupMem = new GlideRecord('sys_user_grmember');
groupMem.addEncodedQuery('group='+ groupSys_id); // append group sys_id
groupMem.query();
while (groupMem.next()){
gs.print(groupMem.user.toString());
}

[Danish Bhairag2 · Accepted solution]

Hi @Anusha Gorige ,

Please try below script

var users = '';
var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('group','<sys_id_of_group>');
gr.query();
while(gr.next()){
    users += gr.user.getDisplayValue() + '\n';
}

gs.info(users);

Thanks,

Danish

[pratiksha5 · Accepted solution]

// Specify the name of the Analyst Group you want to retrieve members for
var analystGroupName = 'YourAnalystGroupName';

// Create a GlideRecord query to fetch members of the Analyst Group
var groupQuery = new GlideRecord('sys_user_grmember');
groupQuery.addQuery('group.name', analystGroupName);
groupQuery.query();

// Check if there are any members in the Analyst Group
if (groupQuery.getRowCount() > 0) {
// Loop through the members and print their details
while (groupQuery.next()) {
var memberId = groupQuery.getValue('user');

// Fetch user details using the user ID
var userQuery = new GlideRecord('sys_user');
if (userQuery.get(memberId)) {
var userName = userQuery.getValue('user_name');
var userEmail = userQuery.getValue('email');

// Print or process the user details as needed
gs.info('User Name: ' + userName + ', User Email: ' + userEmail);
}
}
} else {
gs.info('No members found in the Analyst Group: ' + analystGroupName);
}

[Sohail Khilji · Accepted solution]

Can you share more insite on what your trying to attain, Are your looking just for a script if yes...

var groupMem = new GlideRecord('sys_user_grmember');
groupMem.addEncodedQuery('group='+ groupSys_id); // append group sys_id
groupMem.query();
while (groupMem.next()){
gs.print(groupMem.user.toString());
}

[R1R3 · Accepted solution]

var groupMem = new GlideRecord('sys_user_grmember');
groupMem.addEncodedQuery('group='+ groupSys_id); // append group sys_id
groupMem.query();
while (groupMem.next()){
gs.print(groupMem.user.toString());
}