<div>
You can get a basic listing from the server by viewing the [dbo].[Catalog] table in the ReportServer database:<br />
<br />

<pre><code id="code-20-42860327-1">SELECT Path, Name
FROM dbo.Catalog
WHERE Type = 2</code></pre>
<br />
For what you've specifically listed, it looks like you'd be interested in those two columns, though there are plenty more you could check out too. The server doesn't appear to keep the source RDL file, though by default it's just the name of the report with a .RDL added to the end of it (unless it's been renamed once it was deployed).
</div>


You can get a basic listing from the server by viewing the [dbo].[Catalog] table in the ReportServer database:



SELECT Path, Name
FROM dbo.Catalog
WHERE Type = 2


For what you've specifically listed, it looks like you'd be interested in those two columns, though there are plenty more you could check out too. The server doesn't appear to keep the source RDL file, though by default it's just the name of the report with a .RDL added to the end of it (unless it's been renamed once it was deployed).

<div>
Thanks Ryan, but I would I get information related to the subscriptions mainly to see if its &nbsp;daily , monthly or weekly schedule ?<br />
<br />
Many Thanks
</div>


Thanks Ryan, but I would I get information related to the subscriptions mainly to see if its  daily , monthly or weekly schedule ?

Many Thanks

IT Consultant

gvamsimba

<div>
Brilliant Ryan... Thank you so much
</div>


<div>
<div class="content wysiwyg-content">
Hi,we are migrating our SSRS reports to a new server. Hence I want to prepare a document with the <br />
below information from the report manager. can anyone please guide me the best and easitest way to do this ?<br />
is there any SQL script to do this ?<br />
<br />
Project Folder<br />
Report Name<br />
RDL Source file<br />
<br />
<br />
Many Thanks
</div>
</div>


Hi,we are migrating our SSRS reports to a new server. Hence I want to prepare a document with the 
below information from the report manager. can anyone please guide me the best and easitest way to do this ?
is there any SQL script to do this ?

Project Folder
Report Name
RDL Source file


Many Thanks

Pulling an extract from SSRS Report Manager

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.