Find SSRS report execution time

SELECT
ExecutionLog.ReportID
,TBL_Catalog.”Name” Report_Name
,TBL_Catalog.”Path” Report_Path
,COUNT(*) AS RunCount
,COUNT(DISTINCT ExecutionLog.UserName) AS UserCount
,MIN(ExecutionLog.TimeEnd – ExecutionLog.TimeStart ) Min_Runtime
,Max(ExecutionLog.TimeEnd – ExecutionLog.TimeStart ) Max_Runtime
,AVG(ExecutionLog.TimeEnd – ExecutionLog.TimeStart ) avg_Runtime
,MIN(ByteCount) Min_ByteCount
,Max(ByteCount) Max_ByteCount
,AVG(ByteCount) Avg_ByteCount
,MIN(RowCount) Min_RowCount
,Max(RowCount) Max_RowCount
,AVG(RowCount) Avg_RowCount
FROM
dbo.ExecutionLog ExecutionLog
INNER JOIN
/dbo.”Catalog” TBL_Catalog
ON ExecutionLog.ReportID = TBL_Catalog.ItemID

WHERE ExecutionLog.TimeStart > DATEADD(‘dd’,-30, current_date())
GROUP BY
ExecutionLog.ReportID
,TBL_Catalog.”Name”
,TBL_Catalog.”Path”
ORDER BY COUNT(*) DESC

Leave a Reply

Your email address will not be published. Required fields are marked *