How do I get a list of the reports available on any given reporting server?

Question

I'm wanting to be able to input any given report server url and display a list of reports available on that server.

I found this question, and it's useful if I compile the project with a reference to a specific sql server (How do I get a list of the reports available on a reporting services instance). But (unless I'm just completely missing something which is possible) it doesn't show me how to do what I've stated above.

Answer 1

You could query the ReportServer database of your reporting server.

SELECT *
FROM dbo.Catalog
WHERE Type = 2

Should give you a list of all of the reports.