Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

System table where "Sharing settings" of a Report exist

PB7
Mega Guru

‎12-28-2023 07:29 AM

"Sharing Reports" ServiceNow Doc details the "Share button on Configure tab, or click the Share button in the report header"

Sharing Reports | ServiceNow Developers

 

 

- does anyone know what system table actually holds the records where "Sharing settings" variables are defined e.g. "Groups and Users" 

[Please find attached snip of this UI modal window]

PB7_0-1703777314777.png

 

 

0 Helpfuls
  • 1,203 Views
2 REPLIES 2

Anil Lande
Kilo Patron

‎12-28-2023 07:45 AM - edited ‎12-28-2023 07:46 AM

Hi,

Please check below link:

https://servicenow.com/community/platform-analytics-forum/is-there-report-share-permissions-table/m-...

 

The answer is "sys_report_users_groups" table.

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande
0 Helpfuls

PB7
Mega Guru

‎12-29-2023 04:25 AM

Hi Anil,

 

Thanks for your feedback ; 

While the 'sys_report_users_groups' table  contains the records of each user // group that the report is shared with, my issue is interacting with the radio buttons shown in the snip.

 

Are you aware of how e.g. 'Groups and Users' radio button can be toggled TRUE via fix script?

 

Thanks,

Pat

0 Helpfuls