InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 05:19:09 GMT20http://www.sqlservercentral.com/Forums/Topic856723-150-1.aspxDid 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 mostYou can achieve this from ExecutionLog table, from reportserver database. Example query:[code="sql"]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[/code] take a look in my article:[url]http://www.bidn.com/articles/reporting-services/85/ssrs-information-about-reports-ran[/url]Sat, 30 Jan 2010 15:37:00 GMTMarco André Duarte Francisco