Have you ever had the situation that the reportserver was full of reports but you don’t know if these are even used anymore? To get an overview of the last time an SSRS report was executed you’ll have to dig into the ReportServer database.
To see when the report was last executed I created the following script:
USE [ReportServer] GO SELECT c.[Name] AS [Report Name] , c.[Path] AS [Report Path] , ISNULL(CAST(MAX(CONVERT(VARCHAR(25), e.[TimeStart], 121)) AS VARCHAR), '') AS [Last Execution] FROM [Catalog] c LEFT JOIN [ExecutionLog] e ON e.[ReportID] = c.[ItemID] WHERE c.Type = 2 GROUP BY c.[Name] , c.[Path] ORDER BY c.[Name]
It will show the name, the path and the last execution time time of the report. If the report was never executed the column “Last Execution” will be empty.