Transform Script to Change value for specific users

David Casper
Tera Guru

I have a scheduled data import, using a transform map, to import our users no a daily basis. One of the included fields is 'Enabled' (source) to update the 'Active' (target) field in ServiceNow.

The need is to have a script that looks for a handful of users and changes the Enabled or Active value for them, but only them. I'm a beginner when it comes to programming and have found that this could be done with a onBefore script or maybe a source script.

Latest test is with an onBefore which is allowing the transform to run, but the value is not changing. 

 

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

if(source.login == 'nhesgz');
target.active = false;

})(source, map, log, target);

 

Looking for the best way to do this. Any and all suggestions are welcome. 

1 ACCEPTED SOLUTION

okay, so when we run the script in transform map it run for each row and it will check if source.u_login matches and then it will update at run time. 

 

onComplete() will run once when all the transformations are done for all the records (even after for the user which we wanted to set as inactive) and then it will make those users inactive. 

 

I believe using transform map is better option since you will be checking the u_login user at run time for each row transform, and would taking action right away, instead of using onComplete() with GlideRecord query which will try to glide the sys_user table everytime for every specific records.

View solution in original post

34 REPLIES 34

I tried that script under Transform scripts, no errors, the logs showed the logins correctly, but the logins listed were still active. 

Is there a possibility that a existing business rule is overriding this?

Can you try this with onStart() transform script?

Users are still active 😞 No errors that I could see though. 

Can we give try with below script in onStart()

 

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
	// Add your code here
	var myuserlist = 'nhesgz,teccmm,jpfdjg,CCSRLB,tecrlc,mhhsgx,nrslkz,teckll,teckxb,tecldl,tecdlc';
	var myuserlistarray = myuserlist.split(',');
	for(var i = 0; i<myuserlistarray.length; i++){
		var gr = new GlideRecord('sys_user');
		gr.get('user_name', myuserlistarray[i]);
		gr.active = false;
		gr.update();
	}
})(source, map, log, target);

Users were still active, but a handful of them were locked out this time.