Merging User Records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2017 09:29 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2017 11:21 AM
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();
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2017 12:50 PM
Thank you!