Tuesday, June 21, 2011

How to find the reporting server ExecutionLog information

Use ReportServer
go
SELECT TimeDataRetrieval,TimeStart,TimeEnd,InstanceName,ReportID,
UserName,RequestType,Format,Parameters,TimeProcessing,
TimeRendering,Source,[Status],ByteCount,[RowCount]
FROM ExecutionLog with (nolock)
ORDER BY TimeStart DESC