Solved

Microsoft Reporting Services -- user log ?

Posted on 2014-10-22
1
382 Views
Last Modified: 2014-11-03
I deployed over 500 Microsoft SQL Reporting Services reports in the last 4 years to
http://webserver/Reports/pages/folder.aspx?ItemPath=%2fReports&ViewMode=List

Lots of them probably no longer get used and am willing to upgrade
my "Microsoft SQL Reporting Service" to a newer version if needed.

How can I start a USER LOG to see who is really running these reports ?
0
Comment
Question by:finance_teacher
1 Comment
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 total points
ID: 40398696
I think the logging you need is already there. See this article for the different types of logs:
http://msdn.microsoft.com/en-us/library/ms157403.aspx
Looks like the execution log is the one you are looking for:
The report server execution log contains data about specific reports, including when a report was run, who ran it, where it was delivered, and which rendering format was used.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question