SQL Server - SSRS Report Usage

The ExecutionLog table in the SSRS database (named ReportServer by default) contains quite a lot of nice information about the various reports in an SSRS environment.

For example, you can find out how often each report is used by whom, which formats and statistics on execution times for each dataset and rendering of the report. As an example, execute the query below to find out who last looked at each report and when it was.

 WITH ReportExecution
AS (
SELECT ReportID
,TimeStart
,UserName
,ROW_NUMBER() OVER (
PARTITION BY ReportID ORDER BY TimeStart DESC
) AS rNum
FROM dbo.[ExecutionLog] t1
JOIN dbo.[Catalog] t2 ON t1.ReportID = t2.ItemID
)
SELECT c.NAME AS [Report]
,re.TimeStart AS [Last executed]
,re.UserName AS [User]
,c.[Path] AS [Path]
FROM ReportExecution re
JOIN dbo.[Catalog] c ON re.ReportID = c.ItemID
WHERE re.rNum = 1
ORDER BY re.TimeStart;

/Björn