LDAP: Not all AD Attributes get imported

Alex125
Giga Expert

We like to import data from AD to our User table. And the next Attributes we like to import from AD: sAMAccountName,mail,telephoneNumber,mobile,home,Phone,employeeID

But the only ones we get of that list is sAMAccountName,mail. The rest of that list is not get imported but when we do browsing within ServiceNow I can see them. So there are available from AD/MID server

Off course try it with a empty table and a new table table and switched off   the filter but the same issue..  


Any ideas? We are now on Eureka version.


Browsing we see the AD Attributes   so connection is ok and can get it from AD

BrwoseLDAP.jpg


But after import:

ImportLDAP.jpg



1 ACCEPTED SOLUTION

Yes, the issue is that the import function sample only the first 20 records what it gets in to build the import table. As we import AD from the root the first 20 records had not all the data in them (also get the wrong length of fields etc.) So two options to resolve this.


- Point to OU that has all the data in the first 20 records


- Create those fields manual in the import table. Be sure you use the correct names



Also you need to check you fields format as that is not always correct. Like the source and DN field is only 40 characters long and that should be 255 (not that you ever use that but that is the standard for AD).



And never Clean the whole table as you loose the structure then, so you need to do all the work again..



Hope that helps you.


View solution in original post

15 REPLIES 15

Brad Tilton
ServiceNow Employee
ServiceNow Employee

I would check the attributes field on the LDAP server record (you may have to add it to the form) and make sure you're not filtering any attributes.



LDAP Integration Setup - ServiceNow Wiki


Brad, if you select the advanced view you get the attributes field.


I had it empty then with browsing I get all but not the elephoneNumber,mobile,home,Phone,employeeID   attributes.






When I put sAMAccountName,mail,telephoneNumber,mobile,home,Phone,employeeID   and browse I get only sAMAccountName and mail so that works correct.




I do get them if I use the browser within SN !




Thanks


bernyalvarado
Mega Sage

Hi Alex, you may want to take a look to the following:



a) first try removing the attributes of your LDAP definition and try importing everything. Later you can trim this list after you confirm you're importing the desired elements.


b) make sure you're adding the fields to the transform map in the transform field related list.



Thanks,


Berny


Berny,



a) done that see reply to Brad.


b) I am looking at the import table (see screen shot) that is before the transformation happens to the User table so if it is not there then transforming is not change that..



Thanks