SAMC Technologies staff feel it's important to share our experiences with others as part of our open communication approach.  Please feel free to send us any comments you have regarding our blogs. 

SQL query to pull Reporting Services report execution history.

USE ReportServer
GO
SELECT e.UserName
,e.Format
,e.Parameters
,e.Status
,e.ByteCount
,e.TimeDataRetrieval
,e.TimeProcessing
,e.TimeRendering
,e.TimeStart
,e.TimeEnd
,c.Path
,c.Name
FROM executionlog e
LEFT JOIN Catalog c ON c.ItemID = e.ReportID
WHERE e.UserName LIKE 'myUserId' AND e.Status LIKE 'myReportStatus'
AND c.Name LIKE 'myReportName'