reporting-servicesssrs-2012power-bi-report-server

Is there a way to count the number of reports on a server in SSRS?

I have a lot of reports on SSRS Server, is there a way to query count of all these reports on a specific server.

I didn't try anything as I couldn't find any related answer to my specific question.

Looking for help if it's possible.

Solution

  • On the report server database run the following query:

    SELECT count(*) AS report_count
FROM dbo.Catalog
WHERE type = 2

    This will give you the number of reports on the server