I created a transform map to create bulk incidents.
But the user that gets in the incident was the locked out/inactive users.
How can I get the active users?
I have this transform map onBefore script
1 ACCEPTED SOLUTION
Hi @Vengeful , Open the field mapping and enable the 'Use source script' check box and try with below script.
answer = (function transformEntry(source) {
var grUsr = new GlideRecord("sys_user");
grUsr.addActiveQuery();
grUsr.addQuery('user_name', source.u_user_id); //replace the addQuery as per your data
grUsr.query();
if (grUsr.next()) {
return grUsr.sys_id; // return the value to be put into the target field
} else {
return '';
}
})(source);
Regards,
Sunil
Do you mean to ask that the incident must be created only for active users ?
☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....
