can we have duplicate user names in Servicenow

[deshpandemonica]

Hi All,

I am facing issue with multiple domain AD Accounts. We have 13 domains and it has duplicate usernames. Client wants to allow duplicate usernames and email should be an unique field identifier. Please help me with:

1. is it good practice to allow duplicate user names and coalesce on email id of user.

2. When I try to do the same, it doesn't allow me to insert duplicate user id in user table due to indexing. (Index already exists for at least one coalesce field on table: sys_user.)

Please help me with multi domain LDAP integration.

Thanks & Regards,

Monica

[Michael Fry1]

The email AND userID's will have to be unique. Though it might get confusing when you look at the name and it's someone else.

For your LDAP, you should be coalesce on u_objectguid field. That should be unique to AD.

[deshpandemonica]

Hi Michael,

Thanks for reply. Both u_mail and u_samaccountname are coalesce fields in field mapping of transform map.

Please let me know which field from user table will be mappned to u_objectguid field from AD? I am not sure about this field mapping.

Also, how will you allow users having same username but different domains, can we achieve this functionality?

example:

we have 2 users with username deshpanm but having different domains, one from UK and one from US.

ukoup\deshpanm

usoup\deshpanm

how should I allow both users to access Servicenow. At this moment, only one user is present in Servicenow as userid field is unique. My client wants both users should have access to Servicenow.

Please help.

Thanks & regards

Monica

[Michael Fry1]

Unfortunately you can't have duplication usernames, regardless if the domains are different.

[deshpandemonica]

Thanks Michael for your help !!