My finished modified version includes a couple more pulls/techniques of pulling others associated with manager.
Script below:
var getUsersByManager = Class.create();
getUsersByManager.prototype = {
initialize: function() {
},
BackfillUser:function(){
var idList = ' ';
//Gets users who are listed as managers of other users
var user = new GlideRecord('sys_user');
user.addQuery('managerISNOTEMPTY');
user.addActiveQuery();
user.query();
while(user.next()){
if(idList.length > 0){
idList += (',' + user.manager.sys_id);
}else{
idList += (',' + user.manager.sys_id);
}
}
//Gets users who are listed as group managers
var group = new GlideRecord('sys_user_group');
group.addQuery('managerISNOTEMPTY');
group.addActiveQuery();
group.query();
while(group.next()){
if(idList.length > 0){
idList += (',' + group.manager.sys_id);
}
else{
idList += (',' + group.manager.sys_id);
}
}
//Gets users who have "Engagement Manager" in their title
var user2 = new GlideRecord('sys_user');
user2.addQuery('titleLIKEEngagement Manager');
user2.addActiveQuery();
user2.query();
while(user2.next()){
if(idList.length > 0){
idList += (',' + user2.sys_id);
}
else{
idList += (',' + user2.sys_id);
}
}
return 'sys_idIN' + idList;
},
type: 'getUsersByManager'
};
//Builds a list and returns the list values
