Thursday, 14 May 2015

List recent reports executed

SELECT TOP 1000

c.path

,c.name

,ELS.InstanceName

,ELS.ReportID

,ELS.UserName

,ELS.Format

,ELS.Parameters

,ELS.ReportAction

,ELS.TimeStart

,ELS.TimeEnd

,ELS.TimeDataRetrieval

,ELS.TimeProcessing

,ELS.TimeRendering

FROM [ReportServer].[dbo].[DataSource] ds

JOIN [ReportServer].[dbo].[ExecutionLogStorage] ELS on ELS.ReportID = ds.ItemID

JOIN [ReportServer].[dbo].[Catalog] c on c.ItemID = ds.ItemID

where ds.Name = 'DbNameHere'

order by TimeStart desc

No comments:

Post a Comment