Knowledge Base

With a SQL statement like this:

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
join ReportServer..Catalog AS cat on ex.ReportID = cat.ItemID
order by ex.TimeStart DESC

you can get a lot of details about your your SQL Server Reporting Services (SSRS) activity. But everyone uses Google Analytics, so wouldn’t it be nice to have the data in GA?

Here’s how you can do that.

First download the Google Analytics tracking code. Open the GA tracking code and copy it to the clipboard.

Then find the Reporting Services JavaScript file (reportingservices.js) on your server. It’s usually located in a path such as C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\js. Open it and paste the GA code at the very bottom.

Below that paste in the code to activate GA, replacing the question marks with your own Analytics ID:

var pageTracker = _gat._getTracker(“UA-??????-??”);
pageTracker._trackPageview();

Now you can track your SSRS activity in Google Analytics.

One drawback to this is that you are now effectively using a cached version of the GA code, so if Google releases any important updates you’ll have to manually update your local copy. Theoretically you could dynamically load ga.js from within reportingserver.js and then run the activation code after the load is complete. But this is much simpler. And I wouldn’t be surprised if the next version of SSRS gives you more access to the layout of Report Manager so that you can embed GA the normal way.