Merging User Records

Heather White
Mega Guru

Good afternoon folks,

      I am doing maintenance on our users, and I am finding we have 2 records for the same user, with incidents attached to each.   I was advised by our previous admin to merge the records by updating the incidents of the duplicate user, and then deleting that user from the table.   I am noticing that the incidents are showing a current date as "last updated", which make sense to me, however, the records are also showing a resolved date that matches the update.   I don't know what the overall impact will be on our data.   I have received reports that are "off" as all of the incidents are showing as resolved recently.  

With that being said, is there another way to accomplish the task of pointing all incidents to one user(merging)?

Thanks,

Heather

6 REPLIES 6

Here is an example of the autoSysFields and setWorkflow script. The other one is pretty in-depth and isn't something that could be thrown together quickly.



var incID = ['4717dfe5a9fe198100450448b2404c16'];




for (var i in incID) {


  var incGR = new GlideRecord('incident');


  incGR.get(incID[i]);




  incGR.work_notes = 'Adding a note without updating the system fields!!';


  incGR.setWorkflow(false);


  incGR.autoSysFields(false);


  incGR.update();


}


Thank you!