Centralized reports logging

We are using sql server 2000 reporting services. Management needs to know the
list of reports actually used, their frequency, and all the statistics along
with each one of them such as who, when, where, how long etc.
One way to that is to create a table in sql server and log all the facts
related to these attributes when the report(s) are launched at the front end
(asp.net) side. I am thinking out loud that SSRS must be logging this
information some where.
Is there any way to get to it? If yes, then how. I will google and look at
BOL to see if this could be done. In the mean time, any hints, pointers are
greatly appreciated.
Thank you in advance...RS has a series of reports that include packages you schedule (from SQL
Server). I haven't done this yet (I am doing it for RS 2005 but it uses
Integration Services instead of DTS).
RS 2000 steps
1.Reports you can download
2. Create table
3. Create DTS and schedule. This loads the table with info on usage
4. Run or schedule to run the management reports
You definitely do not need to roll you own with this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sqlster" <nospam@.nospam.com> wrote in message
news:9A9FF399-FF68-45D7-B60D-C1A1BF21242F@.microsoft.com...
> We are using sql server 2000 reporting services. Management needs to know
> the
> list of reports actually used, their frequency, and all the statistics
> along
> with each one of them such as who, when, where, how long etc.
> One way to that is to create a table in sql server and log all the facts
> related to these attributes when the report(s) are launched at the front
> end
> (asp.net) side. I am thinking out loud that SSRS must be logging this
> information some where.
> Is there any way to get to it? If yes, then how. I will google and look at
> BOL to see if this could be done. In the mean time, any hints, pointers
> are
> greatly appreciated.
> Thank you in advance...