Monday, March 26, 2012

Reporting Services 2005

What is the best option to monitor user accesses to published reports? IT department wants to have an idea about the need (value and time) of produced reports.

Regards,

Vitor Mota

I will not comment on what the "best option" is, but this is an option I use frequently for debugging.

If you use stored procedures to generate the data for your reports, you can have them update a stats table to indicate that a given report has been run. You would have to have stored procedures unique to a given report for this to work, but I suppose if you wanted to be fancy, you could write stored procedures just for this purpose.

Otherwise, there are lots of IIS log analyzers out there.

|||

Thanks for your answer.

I'm reading data to reports using MDX queries without using sps and analyzing the IIS logs are hard to do.

I was looking for an "almost" ready solution to use. Any other idea?

Best regards,

Vitor Mota

No comments:

Post a Comment