Table Name Shared Reports

[Rafael Batistot]

Hi Team

Does anyone know which table I can use to see the users or groups with whom reports have been shared?

I have 180 reports created, and I need to see whether they are shared with users or groups — but I don’t want to check them manually one by one.

Is there a table that stores this information?

Thanks!

[Voona Rohila · Accepted solution]

Hi @Rafael Batistot 

Check this table 'sys_report_users_groups' for Reports users/groups.

For Dashboards and it's permissions- check 'pa_dashboards_permissions' table

[Voona Rohila · Accepted solution]

Hi @Rafael Batistot 

Check this table 'sys_report_users_groups' for Reports users/groups.

For Dashboards and it's permissions- check 'pa_dashboards_permissions' table

[Swapna Abburi · Accepted solution]

Hi @Rafael Batistot 

if you are looking for only users and groups then refer to "sys_report_users_groups" table. Also, as report can be shared to roles directly. You can get roles information from "sys_report" table directly using field "roles".