SSRS 2008 R2 – Report Server Database Locations

ssrsssrs-2008-r2

I've recently inherited management of a large number of SSRS environments. I'm attempting to generate a list of all the database server/instance/names for each of the SSRS databases (not the data sources).

These are stored in the rsreportserver.config files, but they are encrypted and I'm not sure how to extract them.

Is there an easy way to get this information from a large number of instances?

If there is a way to do it via command line, I can easily push the command to all servers and collect the output.

Best Answer

Microsoft Assessment and Planning Toolkit should do the trick.

MAP performs a detailed analysis of hardware for migration to Windows 8, Windows 7, Windows Server 2012, Windows Server 2008 R2, SQL Server 2012, SQL Server 2008 R2, Microsoft Office 2010, and Office 365.

It specifically mentions SQL 2012 at some point, but I guess the same would work for 2008 R2 aswell:

Discovery of SQL Server 2012 databases, instances, and selected characteristics.

And here it says:

Detailed reporting:
Covers specific SQL Server instances that include component name, version, edition, and more. Includes wide-ranging details of databases and server instances that can be used for consolidation.

Related Question