ronmichael
1/21/2013 - 12:16 AM

Analyze SQL Server Reporting Services (SSRS) report usage. Note that the log tables do get cleared automatically after 30-60 days or so, so

Analyze SQL Server Reporting Services (SSRS) report usage. Note that the log tables do get cleared automatically after 30-60 days or so, so you need to run this regularly.

SELECT
ex.UserName, ex.Format, 
cat.Path,
cat.Name, ex.Parameters, 
CONVERT(nvarchar(10), ex.TimeStart, 101) AS rundate,
ex.TimeStart, ex.TimeEnd, ex.TimeDataRetrieval, ex.TimeProcessing, ex.TimeRendering, ex.Status, 
ex.ByteCount, ex.[RowCount]
FROM ReportServer..ExecutionLog AS ex INNER JOIN
ReportServer..Catalog AS cat ON ex.ReportID = cat.ItemID
ORDER BY ex.TimeStart DESC