Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

System Table storing who dashboards are shared with

PB7
Mega Guru

- Context: -

'sys_report_users_groups' is the system table where a record exist for instance of a Group or User that a Report is shared with.


E.g.  

"Report X" is shared with "Group I"  and "User P" -- therefore there is a sys_report_users_groups record for "Report X" being shared to "Group I" and another sys_report_users_groups  record for "Report X" being shared with "User P".  

This can be observed in the attached [PFA-0] snip.

 

- Issue: -

My issue is I cannot find a system table to account for the Groups or Users that Dashbaords are shared with. 

Does anyone know which system table holds records accounting for  this? 
E.g. [PFA-1] attached

 

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @PB7 ,

 

You should look at pa_dashboards_permissions

 

AndersBGS_0-1696484647784.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @PB7 ,

 

You should look at pa_dashboards_permissions

 

AndersBGS_0-1696484647784.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Brilliant -- that's the one! Thanks so much Anders.