Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Information about reports ran Expand / Collapse
Author
Message
Posted Saturday, January 30, 2010 3:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 28, 2014 8:26 AM
Points: 30, Visits: 125
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
Post #856723
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse