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