Can we retrieve the list of users having access to a set of Dashboards?

[Sundar16]

Hi Everyone,

I am attempting to create a report or export a list of users who have access to a set of dashboards. While I have located a specific table (sys_report_users_groups) that displays the list of users with access to reports, I have been unable to find a corresponding table for dashboards. 

Any directions would be very helpful.

[Ankur Bawiskar]

@Sundar16 

To find the list of users who have access to dashboards in ServiceNow, you can refer to the pa_dashboards_permissions table. This table stores the details about dashboard access permissions, including which users and groups have access to specific dashboards.

Additionally, here are some other relevant tables you might find useful:

pa_dashboards: Contains the list of dashboards.
pa_dashboards_group: Manages dashboard parent grouping for visibility within dropdowns.
pa_m2m_dashboard_tabs: Stores information about tabs on dashboards13.
You can use these tables to create a comprehensive report on dashboard access.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

Hi @Sundar16 

https://www.servicenow.com/community/sysadmin-forum/dashboard-and-shared-users-question/m-p/2644295