SSRS - tracking report usage

Question

Is there an easy way to track who is running a given report in SSRS 2005, and at what time they are running that report? We have about 80 reports in our SSRS implementation, and are trying to see if there's any that we can safely put out to pasture. If we could easily see somehow which reports aren't being used, that would help us. Any ideas?

Thanks, Chris Valdivia, ADF

Answer 1

Hi

You can monitor the report usage using execution logs. Please check this http://technet.microsoft.com/en-us/library/aa964131(SQL.90).aspx

You can also run a query to find report usage. Check Maz's reply in this link http://www.sqlservercentral.com/Forums/Topic433562-150-1.aspx

cheers

Answer 2

i always found the report logs are a bit hard to use. Reporting services keeps a record of all its activity in a table in the reporting database called ExecutionLog

I have a couple of reports i use that query this table, so you can find out what reports are actually used, and who the heaviest users are

Answer 3

I did a blog on this subject that might help you: http://weblaunch.nl/?p=147

Answer 4

Check out http://www.summitcloud.com/solutions/scrubs to scrub your SSRS log and provide tons of usage reporting. The Community Edition is free on CodePlex!