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.