How do you inventory the reports on a server from the database?

• WebTechie

  SSChampion

  Points: 11405

  More actions

  November 1, 2010 at 5:09 pm

  #240539

  Hello,

  I've recently migrated our SSRS (2005) to a new server running SSRS 2008. The migration was successful.

  Now before I allow the admins to decommission the server, I want to do an inventory of all the reports on the old server. Then I want to inventory the reports on the new server. I would imagine that way, I can insure that the same number of reports are on both servers.

  I'm not sure if there is a TSQL query that may be run to show me the reports that are on a report server. I see the jobs in SQL Agent, but they are all listed by GUIDS.

  How do you find/see the reports that are on a report server? Is there a table where all the reports id,name, date created and so on are kept?

  Thanks,

  Tony.

  Things will work out.  Get back up, change some parameters and recode.

• checkai

  Hall of Fame

  Points: 3041

  More actions

  November 2, 2010 at 8:34 am

  #1245430

  Catalog table on the ReportServer db. You'll have to go based off of report name or ID to match up. I'm unsure if GUIDS transfer over.

• WebTechie

  SSChampion

  Points: 11405

  More actions

  November 3, 2010 at 4:36 am

  #1245903

  Thank you.

  I was able to use SSIS to bring the catalog table from both servers together, create a left outer join and see the difference.

  Thanks again!

  Tony

  Things will work out.  Get back up, change some parameters and recode.