To retrieve a list of all reports on a Microsoft SQL Server Reporting Services (SSRS) instance along with the security principals that have permissions on each report, you can query the SSRS database. SSRS uses a database (commonly named ReportServer
) to store metadata about reports and their security settings.
Use the following query to get the list of reports and their associated security principals:
Continue reading