<div>
Nicobo,<br />
<br />
That is a thing of beauty! Thank you very much.<br />
<br />
Curt
</div>


Nicobo,

That is a thing of beauty! Thank you very much.

Curt

<div>
<div class="content wysiwyg-content">
Can a sql query be created that provides a list of all the reports a user has access to in SSRS? I'm looking for the users that are specified in the &quot;Security&quot; tab of each report in the SSRS database. I'm not concerned with users within a group. &nbsp;We are migrating from SQL 2005 to SQL 2008 R2 and would like to notify the users of each report to take a look at their reports to ensure they are still functioning properly.<br />
<br />
Thanks in advance for any help you can provide.<br />
<br />
Curt
</div>
</div>


Can a sql query be created that provides a list of all the reports a user has access to in SSRS? I'm looking for the users that are specified in the "Security" tab of each report in the SSRS database. I'm not concerned with users within a group.  We are migrating from SQL 2005 to SQL 2008 R2 and would like to notify the users of each report to take a look at their reports to ensure they are still functioning properly.

Thanks in advance for any help you can provide.

Curt

Create list of all reports a user has access to in SSRS

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.