LDAP integration importing wrong data in user (sys_user) table

[rmaroti]

Hi Everyone,

Some external user data will be import in ServiceNow via LDAP integration but it is working fine in test and prod instance but not working proper in Dev instance it is creating duplicate multiple user and wrong mapping (like trim email id.first name. last name in "last name" and "name" field) on target (sys_user) table in DEV Instance i have check transform map, data source, LDAP server and source and target mapping in both dev and test instance are same .

Could you please suggest what will be the cause and please find attached screenshot.

[Shivalika]

I got it @rmaroti 

I was talking about full clone of dev from prod - which will also copy your integration, making it same as how it was..

Or best you do it now, copy all the data sources and transform maps, transform entries, scripts and everything from prod to dev, this will overwrite if anything was changed.

Another thing is revert the version to the same that is in prod - for ALL of the mentioned things. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Ankur Bawiskar]

@rmaroti 

the users you shown are having empty User ID.

Did you check in the import set table if samaccountname came or not?

If the mappings etc are same then it should work fine in all the instances.

Ensure in your transform map this is unchecked

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@rmaroti 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@rmaroti 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.