How to share bulk reports to groups?

[User329467]

Hi,

I have a requirement to share bulk reports to groups. Is it possible with fix script? or?

How to achieve this?

Thanks,

Priyatham.

[Namrata Khabale]

Hey priyatham,

Here are the same threads you looking for, it might help you:

https://community.servicenow.com/community?id=community_question&sys_id=41905121db436740656a5583ca96...

https://community.servicenow.com/community?id=community_question&sys_id=ba5c1951db9a3b00e0e80b55ca96...

https://community.servicenow.com/community?id=community_question&sys_id=16c1828bdb87ab00b1b102d5ca96...

Mark Correct and Helpful, if it helps!

Best Regards,

Namrata.

[Jaspal Singh]

Hi Priyatham,

There exists a Table: Report Users and Groups (sys_report_users_groups) that can be used.

You can write a script that will help you do the same.

var userare=new GlideRecord('sys_user');
userare.addEncodedQuery('active=true');//Pass desired users query here 
//userare.setLimit(10); //uncomment to check for 10 records
userare.query();
gs.print(userare.getRowCount());
while(userare.next())
{

var sharereport=new GlideRecord('sys_report_users_groups');
sharereport.initialize();
sharereport.report_id.setDisplayValue('TimeCard Trend'); //Pass report name
sharereport.user_id=userare.sys_id;
sharereport.insert();
gs.print(sharereport.getRowCount());

}

It can also be altered to make it work for Groups.

[User329467]

Hi Jaspal,

Thanks for the reply, can you make it for groups?

[Jaspal Singh · Accepted solution]

Here you go.

var groupsare=new GlideRecord('sys_user_group');
groupsare.addEncodedQuery('active=true');//Pass desired users query here 
//groupsare.setLimit(10); //uncomment to check for 10 records
groupsare.query();
gs.print(groupsare.getRowCount());
while(groupsare.next())
{

var sharereport=new GlideRecord('sys_report_users_groups');
sharereport.initialize();
sharereport.report_id.setDisplayValue('TimeCard Trend'); //Pass report name
sharereport.group_id=groupsare.sys_id;
sharereport.insert();
gs.print(sharereport.getRowCount());
}

If any of above comments helped you can kindly mark it as Helpful & also get the thread closed once you got things working.