I have 300 odd reports on my sql 2k server, is there a way to track and view
the usage for the reports?Take a look into the the ExecutionLog table in ReportServer database of your
Reporting Service installation.
"beeyule" <beeyule@.discussions.microsoft.com> wrote in message
news:AF1FB30C-340B-46BF-961A-AF74FD974D46@.microsoft.com...
>I have 300 odd reports on my sql 2k server, is there a way to track and
>view
> the usage for the reports?|||Thanks for the help...Is there a way to relate the reportID back to a report
name?
"Oleg Yevteyev" wrote:
> Take a look into the the ExecutionLog table in ReportServer database of your
> Reporting Service installation.
>
> "beeyule" <beeyule@.discussions.microsoft.com> wrote in message
> news:AF1FB30C-340B-46BF-961A-AF74FD974D46@.microsoft.com...
> >I have 300 odd reports on my sql 2k server, is there a way to track and
> >view
> > the usage for the reports?
>
>|||Querying and Reporting on Report Execution Log Data
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"beeyule" <beeyule@.discussions.microsoft.com> wrote in message
news:6803F321-0CF1-403C-86D9-A8A73C5C8A17@.microsoft.com...
> Thanks for the help...Is there a way to relate the reportID back to a
> report
> name?
>
> "Oleg Yevteyev" wrote:
>> Take a look into the the ExecutionLog table in ReportServer database of
>> your
>> Reporting Service installation.
>>
>> "beeyule" <beeyule@.discussions.microsoft.com> wrote in message
>> news:AF1FB30C-340B-46BF-961A-AF74FD974D46@.microsoft.com...
>> >I have 300 odd reports on my sql 2k server, is there a way to track and
>> >view
>> > the usage for the reports?
>>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment