Report/Feature to show what groups are assigned to dashboards and/or reports

[ITProMD]

Hello,

Our organization uses reporting groups, to allow access/control to many different dashboard/reports without needing to each be manually changed. For instance, a manager has 30+ reports, she wants to be able to control who can see those reports, without having to manually touch 30 reports each time a new employee starts whom needs access.

I am curious if anyone knows of a way to report on these reporting groups, to show what dashboards/reports they're currently assigned to?

When customers want to "Deactivate" these groups, we need to ensure there aren't any dependencies before doing so. Almost similar to "Dependency Viewer", it would be nice to have a way to do this with groups.

Any ideas would be greatly appreciated. Thanks!

[HIROSHI SATOH]

For a simple implementation, how about displaying the "sys_report_users_groups" table in the related list of the group form?

[ITProMD]

Thank you, didn't realize we could do this from the related list. Much appreciated!

[AndersBGS · Accepted solution]

Hi @ITProMD , 

For dashboards shared to groups, you should look in the list "pa_dashboards_permissions" within column "group". For reports, look at the table "sys_report_users_groups" in column "group ID" which shows you the reports shared to which groups. 

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

Best regards

Anders

[ITProMD]

Thank you, this was super helpful.