Is it possible to share multiple (400+) reports to 3 users with a script?

[Wilson Ochoa]

Hey everyone,

So I was recently tasked with sharing 400+ reports created by 1 individual amongst 3 users. I am fairly new to service now and I am not too familiar with sharing reports or how to go about this. I am aware that you can share users 1 by 1, however with 400+ reports that could take a long time. I was hoping that I could use a script using a gliderecord that queries all of the reports that I am looking for and then being able to assign each users sysid to all reports that fit the query. If there are any other suggested ways to go about this I would really appreciate the help. I also have checked the article "Bulk sharing own reports" with no luck.

Thank you all,

Wilson

[Austin20]

I know this is an old post, hopefully you can help me out. I'm trying to share multiple reports using your code. I get his error "Could not save record because of a compile error: JavaScript parse error at line (8) column (85) problem = unterminated string literal (<refname>; line 8)". It has a sqiggle line at parentheses "rep.addEncodedQuery(". Any idea on what I need to change?

// users sys_id list to whom you want to share report
var list = "53dd076f1b60c810432b0d0fdc4bcb97";
var arr = list.split(",");
for(i=0;i<arr[i];i++){
var rep = new GlideRecord('sys_report');
// add your encoded query to find multiple reports
rep.addEncodedQuery('title=Report_1
^ORTitle=Report_2
^ORTitle=Report_3
^ORTitle=Report_4
^ORTitle=Report_5
');
rep.query();
while(rep.next()){

var usr = new GlideRecord('sys_report_users_groups');
usr.initilize();
usr.user = arr[i];
usr.report_id = rep.sys_id;
usr.insert();

}
}

[tej_gill]

Hi Austin,

The field to write on "sys_report_users_groups" table is user_id

You can correct usr.user to usr.user_id.

Hope you have found the issue by now. Just wanted to comment here as well.

Cheers.

[Austin20]

Hey Sachin. How would I modify this to work for user groups instead of single users? Thank you!

[tej_gill]

@Austin20,

Similar to user_id field on sys_report_users_groups table, there is group_id field as well that you can utilize to share with groups.

Once again, I hope you have already found an answer to this, but just wanted to add it here for anybody else stumbling on this article.

Cheers.