LDAP Server with three OU definitions retrieving same data on all

Jonas Lundsholm
Mega Contributor

I've got an LDAP server configured which I'm able to browse and load records from.

The LDAP server has three different OU Definitions, with three different RDN's. All of them use "sAMAccountName" as Query field and they are pointing to the sys_user table.

find_real_file.png

If I navigate to the OU Definitions and select "Browse" from the Related links I'm able to view the matching data from each OU. But if I go to the related Data Source and select "Load All Records" I get the same result using all three data sources.

How come I am able to view the correct data when browsing the different OU definitions, but when actually loading records to an import table all three data sources (that are using those OU definitions) load the exact same records?

find_real_file.png

Any help is much appreciated.

12 REPLIES 12

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Jonas,

Are you having single data source for each OU Definition? you should have different ones so that separate set of data is fetched and shown

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,

Yes, I have three data sources as well, one for each OU definition.

The RDN in OU definition specifies where to look for users, but when loading data from Data Source that use the OU definition, I still get data from another OU that is not specified in my definition.

As I mentioned before, when using the browsing feature I'm able to see the correct data, it's only when I load the records that I can see the wrong result.

Here are the OU definitions:

find_real_file.png

And data sources:

find_real_file.png

Hi Jonas,

Ideally it should show different data in the import set tables?

Did you check into the import set table?

Regards

Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hello again,

Yes I've checked and each import set table has the same 57 records.

Not sure how this is possible, I should be able to specify three different OU's and get the data from each OU. The same way I'm able to do when browsing.