use [ReportServer]
SELECT
R.Name
,R.ItemID
, L.TimeDataRetrieval
,L.TimeProcessing
,L.TimeRendering
, L.TimeDataRetrieval+L.TimeProcessing+L.TimeRendering AS TotalTime
,L.Format
,L.[Parameters]
,L.username
,L.TimeStart
,L.TimeEnd
,l.ReportID
,DATEDIFF(SECOND,L.timestart,L.timeend) time_seconds
,r.Path
FROM dbo.ExecutionLog L
INNER JOIN dbo.Catalog R
ON L.ReportID = R.ItemID
WHERE R.Name like 'name of your report'
1条答案
按热度按时间z0qdvdin1#
对报表服务器数据库运行此命令
它会给予你你所要求的一切。。注解出所有报告的出处。你有地方可以开始了。