Information about reports ran

• Marco André Duarte Francisco

  SSC Veteran

  Points: 202

  More actions

  January 30, 2010 at 3:37 pm

  #229524

  Did you know that you can gather information about report execution, for example:

  • How often a report is requested

  • Report duration time (slowest reports)

  • User that ran more reports

  • What formats are used the most

  You can achieve this from ExecutionLog table, from reportserver database. Example query:

  select c.Name as [Report Name],

  e.InstanceName,

  e.UserName,

  e.Status,

  e.Format,

  e.Parameters,

  e.Timestart,

  e.TimeEnd,

  datediff(mi,e.Timestart,e.TimeEnd) ExecutionTime,

  e.TimeDataRetrieval,

  e.TimeProcessing,

  e.TimeRendering

  from ReportServer..Executionlog e

  inner join ReportServer..Catalog c on (e.ReportID=c.ItemID)

  where convert(varchar,e.TimeStart,112) between 20100101 and 20100123

  order by e.TimeStart desc

  take a look in my article:

  http://www.bidn.com/articles/reporting-services/85/ssrs-information-about-reports-ran