SOLVED SCCM Reports - where is the physical location of *.rdl report files

[Christopher Marais]

Hi All,

I am struggling to locate the physical location of SCCM reports *.rdl files. I have a corrupt custom report I need to restore from backup. The problem is I cannot find the report files physical location to use in the restore process. Help on this is greatly appreciated and look forward to your responses.

* The web server "/reportserver" - is part of the SSRS application component and not IIS. So I am unable to locate the virtual directory location withing IIS.
* I have checked the .\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config configuration file which does not hold the answer.
* http://locahost/reportserver - only allows me interact at an application level with no direct access to the report *.rdl folder source.


Regards,

Christopher.

 

[Christopher Marais]

So the physical location for SCCM/Report files *.rdl is .\Program Files\SMS_SRSRP\Reports. This however does not hold the custom reports added.

Does anyone possibly know the physical location of custom reports that one adds. Within SCCM and Reporting Services you can specifically see the folder structure of the virtual directory (sub-directory called FB which holds our custon report) but still unable to locate the physical path.

 

[Garth]

The RDL doesn't exist as files. They exist within the database only.