Duplicate Users in LDAP

amacqueen · ‎07-10-2014

We've been having this issue for some time and I haven't been able to get round to checking until this week. The problem is we have multiple user records being created from our LDAP import.

For example see below:-

A record seems to be created with an email address and another without the email address.

Any initial thoughts? If it would help I'm happy to post our config.

Thanks for looking.

ohhgr · ‎07-10-2014

Hi Angus,

Found a similar discussion (not related to service now),

could you try below line of condition

(&(objectClass=person)(sn=*)(!(objectClass=computer))(mail=*))

Also, mail should be the field storing email in LDAP.

Here's the link where i found it

how to exclude Null or empty fields in a Ldifde export

Thanks,

Mandar

View solution in original post

amacqueen · ‎07-10-2014

As part of my process of elimination I would now like not to import any users who do not have an email address.

Any thoughts please?

JBark · ‎07-10-2014

In the User LDAP Transform Map Field Maps, do you have Colesce = true for u_samaccountname?

amacqueen · ‎07-10-2014

Yes I do Jeff

ohhgr · ‎07-10-2014

Hi Angus,

I haven't written a lot of LDAP Server conditions to be honest. But could you try adding this condition

(&(objectClass=person)(sn=*)(!(objectClass=computer)(!mail="")))

Thanks,
Mandar

amacqueen · ‎07-10-2014

Thanks for the input Mandar but it didn't work.