... TOP 1
'' AS Name,
CONVERT(uniqueidentifier,'00000000-0000-0000-0000-000000000000') AS ItemID
FROM
ExecutionLogStorage
) AS d1
ORDER BY d1.Name ASC
Additional Modifications:
For ...
... e.TimeStart, e.TimeEnd) [Total Time]
,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank]
FROM
[ReportServer].[dbo].[ExecutionLogStorage] e
INNER JOIN
[ReportServer].[dbo].[Catalog] ...
... option 2.
Check this result - Possibly from the Reporting Server ExecutionLog?
Using the ReportServer Execution Logs, we can determine if this is correct
SELECT TOP 1
c.Name,
e.TimeStart, ...
... as to what this database is and how it populates its data.
View: ExecutionLog
InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ...
...
Catalog.Name AS ReportName,
DATEPART(dayofyear, ExecutionLogStorage.TimeStart) AS DayOfYearRun,
DATEPART(week, ExecutionLogStorage.TimeStart) AS WeekRun,
DATEPART(year, ExecutionLogStorage.TimeStart) ...
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.