How do you check if an SSRS report was executed by a user or an automatic refresh in the SSRS SQL database?

339 Views Asked by At

How do you check if an SSRS report was executed by a user or an automatic refresh in the SSRS SQL database?

I'm assuming the answer is in the ExecutionLog table or something it links to, but I can't seem to find the answer anywhere.

A query to start with:

    SELECT  Path Path ,
            Name Name ,
            CreatedBy.UserName CreatedBy ,
            COUNT(DISTINCT ExecutionLog.UserName) DistinctUserCount ,
            COUNT(ExecutionLog.UserName) ExecutionCount
    FROM    Catalog
            LEFT JOIN Users CreatedBy ON CreatedBy.UserID = Catalog.CreatedByID
            LEFT JOIN ExecutionLog ON Catalog.ItemID = ExecutionLog.ReportID
    GROUP BY Path ,
            Name ,
            CreatedBy.UserName
    ORDER BY Path ,
            Name ,
            CreatedBy.UserName

Any help would be appreciated.

0

There are 0 best solutions below