SSRS 2008R2 执行Log 查询

1.　　可以参考ExecutionLog3试图，此为系统安装Reporting Service自带的试图。

 

2.　　可以使用以下语句查询：

SELECT els.LogEntryId,
       els.InstanceName,
       els.ReportID,
       cl.Name,
       cl.Path,
       cl.Description,
       els.UserName,
       els.ExecutionId,
       (CASE(RequestType)
        WHEN 0 THEN 'Interactive'
        WHEN 1 THEN 'Subscription'
        WHEN 2 THEN 'Refresh Cache'
            ELSE 'Unknown'
        END) AS RequestType,
       els.Format,
       els.Parameters,
       (CASE(ReportAction)
        WHEN 1 THEN 'Render'
        WHEN 2 THEN 'BookmarkNavigation'
        WHEN 3 THEN 'DocumentMapNavigation'
        WHEN 4 THEN 'DrillThrough'
        WHEN 5 THEN 'FindString'
        WHEN 6 THEN 'GetDocumentMap'
        WHEN 7 THEN 'Toggle'
        WHEN 8 THEN 'Sort'
        WHEN 9 THEN 'Execute'
            ELSE 'Unknown'
        END) AS ItemAction,
       els.TimeStart,
       els.TimeEnd,
       DATEDIFF( ms,els.TimeStart,els.TimeEnd ) DateDiff_Start_End,
       els.TimeDataRetrieval,
       els.TimeProcessing,
       els.TimeRendering,
       (CASE(Source)
        WHEN 1 THEN 'Live'
        WHEN 2 THEN 'Cache'
        WHEN 3 THEN 'Snapshot'
        WHEN 4 THEN 'History'
        WHEN 5 THEN 'AdHoc'
        WHEN 6 THEN 'Session'
        WHEN 7 THEN 'Rdce'
            ELSE 'Unknown'
        END) AS Source,
       els.Status,
       els.ByteCount,
       els."RowCount"
  FROM dbo.ExecutionLogStorage els WITH ( NOLOCK )
       LEFT JOIN dbo.Catalog cl WITH ( NOLOCK ) ON els.ReportID = cl.ItemID;

 

 

参考资源：

报告服务器执行日志和 ExecutionLog3 视图:

https://msdn.microsoft.com/zh-cn/subscriptions/downloads/ms159110.aspx#bkmk_executionlog2 

Report Server Execution Log and the ExecutionLog3 view

https://msdn.microsoft.com/en-us/library/ms159110(v=sql.105).aspx#bkmk_executionlog3 

SQL Server Report Server 2008 R2 Execution Log Reports

http://www.mssqltips.com/sqlservertip/2722/sql-server-report-server-2008-r2-execution-log-reports/ 

 

 

Solving issue with first long starting report on SSRS 2008

 

http://www.pawlowski.cz/2011/07/solving-issue-long-starting-report-ssrs-2008/ 

MSDN - Reporting Services (SSRS)

https://msdn.microsoft.com/zh-cn/library/ms159106.aspx