Query Details of given SSRS Report from ReportServer Database tables

This is a utility procedure which gives the details like parameters , Datasources , Datasets etc of the given report by querying ReportServer database tables.

 
 
 
 
 
4.2 Star
(34)
Add to favorites
Databases
5/31/2011
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • The namespace is not handled correctly
    1 Posts | Last post March 23, 2017
    • When you have a server that was upgraded and might have different namespaces used in the reports the script has a flaw. 
      When determining the namespace the name of the report should also be checked in the condition.
      'AND C.Name = @ReportName' (After line 24).
      
  • Auto Refreshable Rpts
    1 Posts | Last post March 15, 2017
    • If the report is auto refreshable can you count the original instance, not when it was refreshed, but after it was closed out and opened again - count that instance too?
  • About the query
    3 Posts | Last post October 11, 2016
    • This proc is very helpful. Good job. Your effort and time is truly appreciated.
      Thanks,
      Jason
    • Thank you very much Jason. Very glad to know that the script was very usefull for you.
      
      Warm Regards,
      
      Sorna
    • Thank you for sharing this very useful script.
  • Not all reports are showing up in all result sets
    2 Posts | Last post February 18, 2015
    • The script is great and thanks for posting it. When I query for certain reports they do not show up in the result sets beyond the parameter section As near as I can tell they seem to be set up in the same way. Can you give me any ideas why they may not be showing up? Any help would be appreciated.
    • Could you please check if there are any spaces in the reportname or special charecters ? You can first check by runnning the Select * from Catalog with the report name in the where clause.
  • No question, just a compliment
    2 Posts | Last post October 29, 2014
    • This is extremely useful. Thank you very much for taking the time to write and post this.
    • Thank you very much for your compliment.
  • Is it possible to get the current active connection rather then from deployed XML
    1 Posts | Last post August 01, 2013
    • Thanks for sharing this script, It is really very useful.
      
      I have used the script and it is picking the datasource based on the XML which is been deployed, so let say if we changed the datasource via SSRS report manager then it doesn't get reflected in the XML
      
      Do you have any suggestion for this scenario?
      
      Regards
      Nishar
  • sp Perf
    1 Posts | Last post June 03, 2013
    • Hey Pranav,
      
      I tried running the sp but came accross issues with the first section of the sp (performance wise) which could be to do with how our catalogue is maintained to be fair, to get it working I've altered the first sub select ("x") to contain C.name = @ReportName which seems to speed up the sp. 
      
      Cheers,
      Rik
  • About the query
    3 Posts | Last post August 30, 2012
    • Hello Sir,
               The query you have provided is not running in sql 2008. Its giving an error that"The transact sql debbuger doesnot support the SQL server 2005 or earlier version".so can you provide some help.
      
      Thanks n Regards..
      Pranav Gupta
    • Hello Pranav,
      
        This script is working fine in SQL server 2008 database. I think you are connecting to SQL server 2005 instance through a 2008 SSMS. Please try hitting the execute button instead of Debug and let me know if the problem exists.
      
      Thanks
      
      Sorna
      
    • As described earlier you need to connect to MS SQL Server 2008 [Database Server]. Not just use the 2008 client.
      
      Thanks, Hasham Niaz
  • Query Snapshot Data
    2 Posts | Last post August 21, 2012
    • is there a way to get the content of the Snapshots themselves?
    • Hello Jason ,
      
        Apologize for the delay in the response :(. I didnt look into your question since now. 
        I dont think there is a way you could retreive the snapshot details using a query. 
       
        Please share the details if you have achived this using the query or any other way.
      
      Thanks
      
      Sorna