LDAP import missing values

[bennyphipps]

Hi,

we've got a LDAP data source setup (using a MID Server) which is only pulling in 6000 out of 7000 records.   I can see AD groups that are virtually identical in name and all other attributes (except the obvious ones like ObjectSID, ObjectGUID samAccountname etc) some which are included and others which are not there's no fields with massive values in either etc.

This is not a problem with Transform map as the data is missing from the import itself.   I've tried clearing down the Filter in the OU Definition and that made no difference either.

I can view the AD Groups from the instance when I use the LDAP Browse functionality ok though.

Can anyone help or suggest anything?   My import table field sizes are all pretty large to account for truncation etc but some of the groups.

Cheers,

Ben

[poyntzj]

Not sure about what some of those show, especially the sAMAccountName<=a and so on

I'll do another import on our test instance tomorrow and see if I can get any from our logs.

I suspect as we are a VPN there will not be anything that matches or really assists - but you never know.

I would use the work around to get the groups in now so you can do what you want, then wait to see if someone can provide assistance via HI and provide the real solution - which I'll be interested in hearing too.

[nate_weldon]

What port are you using to attach to the LDAP Server? I'm assuming this is Active Directory LDAP. Make sure you aren't going through the port for Global Catalog server, I can't recall which it is. Also, what do you see when you browse the OU from ServiceNow without a filter applied.

[nate_weldon]

you can try using filter objectClass=group to narrow down the list.

[bennyphipps]

Browisng OU with no filter supplied shows values... however it's only limited to 1000 records so not that useful tbh.

port is 636 standard one for LDAPS

[bennyphipps]

Daniel Bye can you remember if there was anything specific we had to do for LDAP imports...?

Don't expect an answer but any ideas / suggestions would be appreciated of course as this problem is weirding me out tbh