SSRW Report Execution History

An easy way to track who is running a given report in SSRS.

CREATE VIEW [Reports].[vw_Report_DBA_Report_Usage]
AS
    SELECT TOP 100 PERCENT
            a.Name AS ReportName ,
            b.UserName ,
            b.Status ,
            b.TimeProcessing AS ProcessingTime ,
            b.TimeStart ,
            a.Path
    FROM    Catalog a
            INNER JOIN ExecutionLog b ON a.ItemID = b.ReportID
    ORDER BY b.TimeStart DESC
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License