Report usage monitoring

Question

Report usage monitoring

robin-892784

Say Hey Kid

Points: 672
More actions
August 26, 2009 at 9:15 am

#209974

Is there a feature/module that enables monitoring of report usage at a granular level, such as which user has been accessing and running individual reports in SSRS, and what parameters they were using?
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

You can get this information from the exectionlog table in the ReportServer database. There may be some 3rd party that has written some reports using this, but I don't know for sure.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Sneh Agrawal Right there with Babe Points: 770 More actions · Answer 2

Execute the following query on the Report Server:

use reportserver

go

SELECT

ex.UserName, ex.Format, ex.TimeStart, cat.Name, ex.Parameters, CONVERT(nvarchar(10), ex.TimeStart, 101) AS rundate

FROM ExecutionLog AS ex INNER JOIN

Catalog AS cat ON ex.ReportID = cat.ItemID

ORDER BY ex.TimeStart DESC

denglishbi SSCrazy Eights Points: 8831 More actions · Answer 3

You can download and setup the sample reports that will allow you to create a reporting repository based off the execution log. This is part of the sample reports on CodePlex for the Server Management Report Samples.

You will need to download the appropriate version for 2005 or 2008 - http://msftrsprodsamples.codeplex.com/[/url]

Here are some instructions - Monitoring Report Execution Performance with Execution Logs

----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com

Jack Corbett SSC Guru Points: 184394 More actions · Answer 4

Thanks for posting the link Dan. May come in handy.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

robin-892784 Say Hey Kid Points: 672 More actions · Answer 5

robin-892784

Say Hey Kid

Points: 672

August 27, 2009 at 4:45 am

#1045418

Thanks for all the responses guys - v helpful.

SSSolice SSCommitted Points: 1907 More actions · Answer 6

Also look at the ReportSchedule table in the ReportServer catalog for your timed subscriptions.

And, if you happen to use one of the 3rd party reporting tools (developed around .net and the SSRS extensions) then you may find these fields useful as well.

,Catalog.Name

,Catalog.Path

,Catalog.Description