Query the SSRS RDL repository

Epicor ERP 10
1

I’d like to query the RDL repository to get the Last modified date of each object (Reports and Folders) in our SSRS. I can see them when I use the report browser like:

image
image.png987×523 48.2 KB

But I’d have to manually enter each folder and sub folder, if using the browser.

Ideally it would be like a directory listing:

reports\1099Form                                    06/26/2016 06:00 PM
reports\1099Form\1099Form.rdl                       02/16/2017 10:40 AM
...
reports\ARInvForm                                   06/26/2016 06:01 PM
reports\ARInvForm\AllocDeposits.rdl                 02/16/2017 10:41 AM
reports\ARInvForm\ARForm.rdl                        02/16/2017 10:45 AM
reports\ARInvForm\ARForm_Fin Charges.rdl            02/16/2017 10:41 AM
reports\ARInvForm\ARForm_kits.rdl                   02/16/2017 10:41 AM
reports\ARInvForm\ARForm_Misc Charges.rdl           02/16/2017 10:41 AM
reports\ARInvForm\ARForm_MultiPayment_Details.rdl   02/16/2017 10:41 AM
reports\ARInvForm\ARForm_Services.rdl               02/16/2017 10:41 AM
reports\ARInvForm\ARForm_Taxes.rdl                  02/16/2017 10:41 AM
...
reports\CustomReports\ARInvForm                     04/30/2019  1:22 PM
reports\CustomReports\ARInvForm\AllocDeposits.rdl   08/29/2017  8:36 AM 
< and so on....>

This possible in SSMS?

2 
use ReportServer

select [Path], [CreationDate], [ModifiedDate] from [dbo].[Catalog]

I’m not sure if ReportServer is the default name SSRS uses, but that’s what it’s named on our server. There’s also a Type column in the table. Looks like 1 means folder and 2 means RDL.

image
image.png742×528 33.9 KB

4 Likes
3

Awesome!!! I wish I could like your post twice!!