Sync between AD and Servicenow Users?

KM SN
Tera Expert

‎06-20-2024 11:25 PM

People have configured ldap server to make users & groups sync in place b/w SN and AD.

the sync is taking place for every 5 minutes? but an incident is raised saying that despite he is there in AD his account not found in SN users.  

 

when i went back and see the import set error log i have seen below info.

Import set row error form.pngImport set row error.png


1) When I am able to see the sync for every 5 minutes why I am only seeing only two set of import set row errors.

2) I am not able to find the reason for error, how can I find it?

0 Helpfuls
  • 253 Views
2 REPLIES 2

Slava Savitsky
Giga Sage

‎06-20-2024 11:44 PM

Most probably, a user record with the same user_name (or some other attribute that must have a unique value) already exists in the User [sys_user] table. You may need to configure the coalesce settings in your Transform Map so that the system updates the existing user record instead of trying to create a new one.


Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
0 Helpfuls

KM SN
Tera Expert
In response to Slava Savitsky

‎06-20-2024 11:58 PM - edited ‎06-21-2024 12:00 AM

Thanks for reply Slava Savitsky

I found the email allocated to this person was allocated to some one else already but that user is already deactivated and locked out in stage.  This might becomes the issue if they have kept coalesce is true for email but they are using some other field for coalesce called guid which is generating from AD so obviously this will not be the issue right?



0 Helpfuls