Script to Initialize and add multiple AD groups

[Kaz9]

Hello community!

      I am trying to get a script working that queries a variable on my form and adds those string values as ad groups to the username requested by the parent workflow.

Here is my script

var gr = new GlideRecord('x_prole_onboarding_onboarding');

gr.addQuery('u_string_105', current.variables.position); //job title field

gr.query();

var groupList = "";

var group = []; // this will be an array of objects

while (gr.next()) {

groupList = gr.u_sharepoint_groups;

group = groupList.split(',');

}

workflow.scratchpad.count = group.length; // the overall count available

workflow.scratchpad.groupList = groupList; // the list of AD groups

workflow.scratchpad.group = group;

workflow.scratchpad.counter = 0;   // our counter

workflow.scratchpad.host = '10.100.33.100';

workflow.scratchpad.user = current.variables.username;

Here is a picture of the Activity Properties to add user to group

here is a picture of the variable it is trying to pull information from

I am getting over the right server IP and the right username but I cannot get it to use that list as AD groups to add in the activity. Any help would be great! please let me know if you need additional information. Thank you!

[Kaz9]

can you get me some more information? what is the process that you are using for that form? is it a catalog item that is filled out and then a workflow is generated? for the domain controller just put the IP address of whatever your active directory domain controller is. I think ours is going through a mid server though. can you send me some screen shots of what your form looks like? and what your workflow is?

[gtk]

we are trying to add/remove users from AD

in catalog item

requested for is user

group is to which group has to be add/remove

this is catlog item

in action : add/remove option

in domain : we have two domains

in AD group : list fo grops available

from checkout screen requsted for fiels is availabe  

[mev]

Out of curiosity, aren't you only applying the first group in your array to the users AD account?  From the example above, in your "Add user to AD group" activity, you set the 'Group Name' field to: ${workflow.scratchpad.group[workflow.scratchpad.counter]}

And since you declared in your run script that workflow.scratchpad.counter = 0;   Wouldn't this only apply the first group/object in your array to the users account?

Sorry to nitpick, I'm just trying to understand your code since I also need to apply multiple groups to an AD account. I'm having some issues though.

My post is here: 

https://community.servicenow.com/community?id=community_question&sys_id=45aa0673db16db04fac7f4621f961941&anchor=answer_76cf963bdb1a5744852c7a9e0f961947

[Steven Young]

What is your "If" conditions?   in the Check Counter?

[kazidon]

// This script needs to set answer to 'yes' or 'no' to indicate the state of the activity.
//
// For example,
//
//   answer = ifScript();
//
//   function ifScript() {
//      if (condition is true) {
//         return 'yes';
//      }
//      return 'no';
//   }
answer = ifScript();  
  
function ifScript() {  
            var check = 'no';  
            workflow.scratchpad.counter ++;  // increment the counter  
          
            // check the counter and see if we need to go again or stop  
            if (workflow.scratchpad.counter < workflow.scratchpad.count) {  
                        check = 'yes';  
            }  
          
            return check;  
}