Report Hit Counts

This is gonna be simple - but not for me!!
I need to record the number of hits each report gets from users. As a bonus,
also the parameter values passed would be usefull also.
What would be the simplist and most efficient way of achieving the above
please.
Thanks and Happy New Year
TonyThe report server automatically logs all Report Executions. Look at the
Execution Log table. More info can be found here:
http://msdn2.microsoft.com/en-us/library/ms155836.aspx
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony Scott" <TonyScott@.discussions.microsoft.com> wrote in message
news:43FF9683-CA87-414F-890A-5D1F310F8E5B@.microsoft.com...
> This is gonna be simple - but not for me!!
> I need to record the number of hits each report gets from users. As a
> bonus,
> also the parameter values passed would be usefull also.
> What would be the simplist and most efficient way of achieving the above
> please.
> Thanks and Happy New Year
> Tony|||More than what Daniel has said, there is a sample package with reports, and
SSIS package which parses the logs, moves the data into a table, and provides
about 6 reports against them... It is exactly what you need.
Look for it in the samples for SQL..
(The reports are really nice!>)
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Tony Scott" wrote:
> This is gonna be simple - but not for me!!
> I need to record the number of hits each report gets from users. As a bonus,
> also the parameter values passed would be usefull also.
> What would be the simplist and most efficient way of achieving the above
> please.
> Thanks and Happy New Year
> Tony