... e.TimeStart, e.TimeEnd) [Total Time]
,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank]
FROM
[ReportServer].[dbo].[ExecutionLogStorage] e
INNER JOIN
[ReportServer].[dbo].[Catalog] ...
...
e.TimeDataRetrieval + e.TimeProcessing + e.TimeRendering AS TotalTime
FROM
[ExecutionLog] e
INNER JOIN [Catalog] c ON c.ItemID=e.ReportID
WHERE c.Name='My Amazing Report' -- just change the value ...
... ,a.[Status]
,a.[ByteCount]
,a.[RowCount]
FROM [ReportServer].[dbo].[ExecutionLog] a
INNER JOIN [ReportServer].[dbo].[Catalog] b
ON a.ReportID = b.ItemID
The Top 5 Most ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.