question LDAP Integration in API Insights forum

LDAP Integration

SanketKumaS — Thu, 28 May 2026 05:12:40 GMT

How to source the groups and group members from the LDAP server aligning to the users already present on the ServiceNow platform?User records have come into the sys_user from another source by LDAP Integration only. We need to make sure that duplicate members should not be created in the sys_user table.We want that new data should come to sys_user_group for the groups and to sys_user_grmember for the members.

Re: LDAP Integration

Ankur Bawiskar — Thu, 28 May 2026 05:20:28 GMT

@SanketKumaS

group and group membership not coming from same LDAP?

Re: LDAP Integration

Tanushree Maiti — Thu, 28 May 2026 05:26:00 GMT

Hi @SanketKumaS

Use the standard LDAP Integration but with a specific onBefore transform script ,make sure Coalesce has been properly set . This method ensures that group memberships are created only for users who already exist in your sys_user table, effectively preventing the creation of duplicate or unwanted user records.

Sample onBefore transform script:

var userGr = new GlideRecord('sys_user');
userGr.addQuery('user_name', source.u_sAMAccountName); // Replace by your Ldap fielduserGr.query();if (userGr.next()) {
    var userId = userGr.sys_id;    var groupGr = new GlideRecord('sys_user_group');
    groupGr.addQuery('name', source.u_department); // Replace your LDAP group field here    groupGr.query();
    if (groupGr.next()) {
        var groupId = groupGr.sys_id;
        // Check if the membership already exists to prevent duplicate sys_user_grmember entries
        var memberGr = new GlideRecord('sys_user_grmember');
        memberGr.addQuery('user', userId);
        memberGr.addQuery('group', groupId);
        memberGr.query();        if (!memberGr.hasNext()) {
            memberGr.initialize();
            memberGr.user = userId;
            memberGr.group = groupId;
            memberGr.insert();
        }
    }
}

Refer Servicenow documentation: LDAP transform maps

LDAP integration creating Duplicate Accounts in User Table

Re: LDAP Integration

SanketKumaS — Thu, 28 May 2026 07:49:25 GMT

No the users have come from a different data source only by using transform maps.But the groups and group members are to come from LDAP source.Need to make sure there are no duplicate users created for the already existing users.

Re: LDAP Integration

SanketKumaS — Fri, 29 May 2026 06:46:57 GMT

Actually I need to modify the Transform Scripts written for the Users OU Definition so that the group members are mapped to the group without creating duplicate users in the sys_user table based on a particular filter.Currently,OnStart and OnComplete transform scripts are used.I need to modify them to fulfil my requirement.

Re: LDAP Integration

SanketKumaS — Fri, 29 May 2026 06:58:21 GMT

My goal is that to map the LDAP group members with the existing user record without creating duplicates in the sys_user table.

Re: LDAP Integration

Ankur Bawiskar — Fri, 29 May 2026 06:59:42 GMT

@SanketKumaS

if your question is unanswered then I will request to keep thread open so that members can guide you

Re: LDAP Integration

Tanushree Maiti — Fri, 29 May 2026 07:07:56 GMT

Hi @SanketKumaS

Check in existing script if above field has been mapped. if not

Just add a new one - onBefore Transform script.

Re: LDAP Integration

SanketKumaS — Fri, 29 May 2026 07:20:57 GMT

Yes please keep the thread open

Re: LDAP Integration

SanketKumaS — Fri, 29 May 2026 11:12:16 GMT

There is a slight change in the requirement.I need to use a specific filter to source only the ServiceNow relevant groups from LDAP.I need to map the group members with the already existing users making sure no duplicate users are created.Currently the LDAP Server has only one OnStart and OnComplete transform script.The OnStart script is just calling the LDAPUtils script include and using the setLog(log) for setting the logs.While in the OnComplete transform script,it is calling the processManagers() function of the LDAP.Please help me.

Re: LDAP Integration

Tanushree Maiti — Fri, 29 May 2026 11:51:53 GMT

Hi @SanketKumaS

Will check and get back