Transform Map - Active Users only

Community Alums · ‎12-17-2023

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

SunilKumar_P · ‎12-18-2023

Hi @Community Alums , 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

View solution in original post

Community Alums · ‎12-17-2023

Do you mean to ask that the incident must be created only for active users ?

Community Alums · ‎12-18-2023

@Community Alums

Yes

Tai Vu · ‎12-17-2023

Hi @Community Alums

You can do your custom script in your Field Map, querying to get the Active User then return the User sys_id since you're doing mapping on the reference field User.

In your Transform Map, How do you currently map the User field? What is the User value in your Source (staging table)?

Cheers,

Tai Vu

Community Alums · ‎12-18-2023

@Tai Vu
Here's the map for user field.