January 30, 2010 at 3:37 pm
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply