Sharing of Reports with users and groups, how does it work with update set?

[Ayushi5]

I wanted to understand, Since Users and Groups aren't captured in the update sets and if I create a report and share it with particular groups and users in lower environment so when I migrate that update set to other environment, how will the sharing work? Will I have to share the reports to the groups and users of that environment again? How does it work?

[shloke04 · Accepted solution]

Hi,

Please follow the steps below to achieve your requirement:

You do not need a script here to achieve what you are looking for:

1) Couple of things to make a note of while moving Report shared list. You need to make sure the users with whom you have shared your report with are also available in both the instance with same details so that when you move the report ServiceNow can reference it correctly. I have seen scenario where user were not same and it was showing as blank in Target instance.

You do not need to add Users and Groups manually in your target instance. Navigate to the Table named as "Report Users and groups" by typing "sys_report_users_groups.LIST" in Application Navigator Search menu as shown below:

Now Put a Filter condition as shown and the just Export the filtered record as XML as shown below:

Right click on the header and then select Export-XML as shown below:

Now navigate to your Target instance, and then click on Retrieved Update Set and click on Import XML as shown below:

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[shloke04]

Hi,

The way suggested above does not requires you to use any script and is easy to use.

If your query is resolved, please mark the answer as correct and close this thread for others.

Regards,

Shloke