Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Report Access table

  1. Last updated
  2. Save as PDF

What is the table in the database that stores the resources that have access to a particular report?

How can I get the list of such resources who have access to a particular report ?

The following 2 table will list the resources by role and by resource :

1. Multipurposeroles
2. Multipurposeresource

Execute the below query to get the resources list for the respective report. Change the 'specify report name here' with the name of the report.

select DISTINCT r.ResourceID, r.Name
from resources r
JOIN resourcerole rr ON rr.ResourceID = r.ResourceID
JOIN Multipurposeroles mpr ON mpr.RoleID = rr.RoleId
JOIN Report rpt ON rpt.ReportID = mpr.id
where rpt.name = 'specify report name here' order by r.name