T SQL to get list of reports and other related info

• SSCNewbee

  Right there with Babe

  Points: 788

  More actions

  June 22, 2016 at 6:53 am

  #319579

  Hi All,

  I want to check how many reports are running on my report server and how long it takes and all the other info like how many users accessed , when was it accessed last and latest....

  Any link where i can find the sql for that?

  Thanks

• durga.palepu

  Hall of Fame

  Points: 3530

  More actions

  June 22, 2016 at 7:05 am

  #1886229

  You need to query the ReportServer Catalog table to get the reports running statistics.

  The following links would help you:

  http://sqlsrv4living.blogspot.in/2014/01/ssrs-get-list-of-all-reports-using.html

  https://thesqlpro.com/2012/07/09/ssrs-report-usage-statistics/

• SSCNewbee

  Right there with Babe

  Points: 788

  More actions

  June 22, 2016 at 9:10 am

  #1886304

  Thanks a lot Durga.