
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-07-2018 10:57 AM
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.
Solved! Go to Solution.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-08-2018 09:39 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-08-2018 06:20 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-08-2018 06:25 AM
Can you try this with onStart() transform script?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-08-2018 06:30 AM
Users are still active 😞 No errors that I could see though.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-08-2018 06:47 AM
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);

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-08-2018 06:55 AM
Users were still active, but a handful of them were locked out this time.