Change Report Owner

[shembop]

I have several reports that were created by a person who has set them up to be shared with multiple people, and also scheduled them to be emailed. The person has left the company, and I would like to transfer the report to a new "owner" Is there a way to assign this to a new person so as to not recreate everything?

[nrentmee]

I also have the same problem.   Where do you change the user ID?  

[Tony DiRienzo]

The correct answer to this question is to change the Created by user (created_by_user) field on the report.  The User field controls who is able to view the report, and if you overwrite that field, the users/groups who were previously listed there will no longer be able to view the report.

[Scott Jordheim]

Did you have to deactivate any UI policies for this? When I was attempting this via file properties on some reports, it didn't change any settings. I'm assuming this would have to be done from the List View for that table.

[Tony DiRienzo]

Hi Scott,

I used a fix script to change this setting:

var reports = ''; // comma separated string of report sys_ids
var reassign_to = 'user sys_id goes here'; // sys_id of the new report owner

var gr = new GlideRecord('sys_report');
gr.addQuery('sys_id', reports);
gr.setValue('created_by_user', reassign_to);
gr.updateMultiple();

Most direct editing of report records is disabled by default.  To edit the Created by user field from list view, you would need to enable editing on the List Control for the reports table (as mentioned above by Slava).

I hope this info helps.

[Scott Jordheim]

It does, thanks!