Is it possible to get the SSRS Site URL from the ReportServer database?
The ReportServer.ConfigurationInfo returns a blank URL, but does return the site name. It feels like the Reports Service should know about the database, not the other way around - so I expect not.
Would be useful to know, for reporting, auditing, management, etc. I am using to periodically clean out stale subscription emails, etc. across multiple servers / databases.
No, the URLs are stored in the registry with the key names RSVirtualRootApplication and RSVirtualRootServer in the following path:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSRS{Version Number}.{InstanceName}\Setup
So, if you're running a 2012 instance, with the default instance name, then the penultimate path would be MSRS11.MSSQLSERVER.
Though you can inspect the registry using T-SQL, I would personally advise against it, and use a different method; such as Powershell.