Audit RS

I am trying to perform an audit of all of the reports and their respective
datasource, subscprition, etc., our RS server. Is there any pre-fab report
out there that already does this or do I need to build my own report using
the ReportServer db? If it's the latter, is there a schema for the tables?
Thx,Has anyone been able to come up with an answer to this? I am also wanting to
know this information as well as where it's logged whether a report succeeds
or fails as a scheduled event.
"Robert" wrote:
> I am trying to perform an audit of all of the reports and their respective
> datasource, subscprition, etc., our RS server. Is there any pre-fab report
> out there that already does this or do I need to build my own report using
> the ReportServer db? If it's the latter, is there a schema for the tables?
> Thx,|||Look at the following directory on your hard drive (assuming you installed
the code samples for MSSQL 2005):
C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report
Samples\Server Management Sample Reports
There's a solution (.sln file), a readme, an SSIS package and some sample
reports that allow you to monitor report usage. If you want to do this over
time, you would have to schedule the SSIS package to run periodically.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Michael" <Michael@.discussions.microsoft.com> wrote in message
news:8C6F5F5B-9D15-49C5-8347-6A7936128CA5@.microsoft.com...
> Has anyone been able to come up with an answer to this? I am also wanting
> to
> know this information as well as where it's logged whether a report
> succeeds
> or fails as a scheduled event.
> "Robert" wrote:
>> I am trying to perform an audit of all of the reports and their
>> respective
>> datasource, subscprition, etc., our RS server. Is there any pre-fab
>> report
>> out there that already does this or do I need to build my own report
>> using
>> the ReportServer db? If it's the latter, is there a schema for the
>> tables?
>> Thx,