Need to restrict the Duplicate User Record

Arun91
Tera Contributor

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.

5 REPLIES 5

AD has a sys id for each user, coalesce on that value instead. It will always be unique and it will not change.