Get a list of RDL that have been deployed?

  • jbalbo

    SSCertifiable

    Points: 7456

    Hi

     

    Trying to clean up a VS RS project.

    Is there a way to get a list of the RDL files that have been deployed to the web interface ?

     

    Thanks

  • Site Owners

    SSC Guru

    Points: 80373

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • anthony.green

    SSC Guru

    Points: 112483

    Query the catalog table in the ReportServer database that will give you what has been deployed to the web interface, but remember some things may have come from other projects so you can't see what actually came from this particular project your tidying up.

  • Anand929

    Grasshopper

    Points: 22

    I use below query to get the list of all reports deployed in report server -

    SELECT Name from ReportServer.dbo.Catalog WHERE Type=2

    Type 2 represents report object in table.

    Anand

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply