Home > Reporting Services > Get SSRS Report Stats, Usage report and Runtime

Get SSRS Report Stats, Usage report and Runtime

October 12, 2016 Leave a comment Go to comments

 

SELECT 
       Cat.[Name] AS ReportName, 
       Cat.[Path] AS ReportPath, 
       ELog.[Format] AS ReportFormat, 
       ELog.[UserName] AS RunBy, 
       ELog.[TimeStart] AS RunDateTime, 
       CONVERT(nvarchar(10), ELog.[TimeStart], 101) AS RunDate,  
       CASE(ELog.[Source])
              WHEN 1 THEN 'Live'
              WHEN 2 THEN 'Cache'
              WHEN 3 THEN 'Snapshot' 
              WHEN 4 THEN 'History'
              WHEN 5 THEN 'AdHoc'
              WHEN 6 THEN 'Session'
              WHEN 7 THEN 'Rdce'
              ELSE 'Unknown'
       END AS [DataSource],
       CASE(ELog.[RequestType])
              WHEN 0 THEN 'Interactive'
              WHEN 1 THEN 'Subscription'
              WHEN 2 THEN 'Refresh Cache'
              ELSE 'Unknown'
       END AS RequestType,
       1 AS [NumRuns], 
       ELog.[TimeDataRetrieval],
       ELog.[TimeProcessing],
       ELog.[TimeRendering],
       ELog.[ByteCount],
       ELog.[RowCount]
FROM ELogecutionLog AS ELog 
INNER JOIN [Catalog] AS Cat ON ELog.ReportID = Cat.ItemID 
WHERE Cat.Type = 2
AND ELog.[TimeStart] >= '2016-08-01'
ORDER BY ELog.TimeStart DESC


 


  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: