Need to restrict the Duplicate User Record
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-06-2024 08:07 AM
Hi Team,
We have integrated servicenow with AD. When the user account is created it is getting sync and it is inserting into the sys_user table. In AD if they modified the userid and in servicenow new user account is getting created. We just want to restrict it if email id is same then it should not insert instead of it should update. How we can proceed it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-06-2024 08:10 AM - edited 08-06-2024 08:11 AM
Coalesce on email id field. This way if the user id changes but the email id is the same then it will update the user. If the email id changes, you will have the same issue.
Speak to the team that manages AD and see if there is a sys id that you can map and coalesce on instead of values that can change.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-06-2024 08:15 AM
Is there any way that if we create transform on before script in servicenow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-06-2024 08:18 AM
Yes that is possible but it is not necessary to meet your requirements.
Coalescing on the field that will not change will prevent the new users from being created
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-06-2024 08:21 AM
Problem is sometime user id will be wrong sometimes email id will be wrong. But in AD there will be only one user account but in servicenow it will be two entry.
