report usage...

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?
>>

Report Usage Tracking

In SRS 2000/2005, is there a way to get usage tracking for report access? Is
there a way to track how often a particular report is accessed and with what
parameters?
This would be extremely useful.The Execution Logs can give you that kind of info.
http://msdn2.microsoft.com/en-us/library/aa964131.aspx
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"BillG_SD" <BillGSD@.discussions.microsoft.com> wrote in message
news:754DD946-A84C-4633-A1F4-1494491C85A6@.microsoft.com...
> In SRS 2000/2005, is there a way to get usage tracking for report access?
> Is
> there a way to track how often a particular report is accessed and with
> what
> parameters?
> This would be extremely useful.
>

Report usage stats

Is there anyway I can see who has ran what reports and when? I have so many
reports that have been requested and I have a feeling they are not being
used.check out this link. should provide you exactly what you need using the
reporting services execution logs.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp
"DJTN" wrote:
> Is there anyway I can see who has ran what reports and when? I have so many
> reports that have been requested and I have a feeling they are not being
> used.

Report usage in SQL2005 RS

Is there a SSIS equivalent to the information in DTS package described at
http://msdn2.microsoft.com/en-us/library/aa972246(SQL.80).aspx '
If not, is it possible to install the DTS package and migrate it to SSIS?Make sure Samples are installed on your MSSQL 2005 server. Then go to:
C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report
Samples\Server Management Sample Reports
There's a solution (Server Management Sample Reports.sln) that contains an
SSIS package and some sample reports. Read the
readme_ServerManagementReports.htm file for instructions.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"William" <William@.discussions.microsoft.com> wrote in message
news:B0511D2D-77F1-4FFC-A070-A8FE2C47C567@.microsoft.com...
> Is there a SSIS equivalent to the information in DTS package described at
> http://msdn2.microsoft.com/en-us/library/aa972246(SQL.80).aspx '
> If not, is it possible to install the DTS package and migrate it to SSIS?

report usage

I'm trying to establish usage statistics on my reports...I got a tip to look
at the executionlog table on my reportserver database. This looks like it
might do the trick, but it lists the reports in a "reportID" column that
looks like a system generated unique id. Is there a way to related the
report ID back to the name of an individual report?Join ReportID in the table ExecutionLog to the ItemID field in the
Catalog tablesql