... work on your reporting server as well. I'm using the database "ReportServer".
select * from
(
SELECT TOP 1
c.[Name] AS [ReportName]
, e.[ReportID] AS [ReportID]
, e.[TimeStart] AS [TimeStamp]
, ...
...
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 ...
...
ReportID uniqueidentifier NULL The ID of the report (looks like a hexadecimal SSID). It's the unique ID of the report but not unique in the table (can be referenced many times).
UserName nvarchar(260) ...
... AS YearRun,
COUNT(Catalog.Name) AS Counter
FROM
ExecutionLogStorage
INNER JOIN
Catalog ON ExecutionLogStorage.ReportID = Catalog.ItemID
WHERE
(Catalog.Type = 2)
AND ...
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.