Reporting Services logs and database tables

elsvieta 346 Reputation points
2024-05-27T12:41:11.9033333+00:00

hi all,

Do the RS logs and various log database tables contain the same information?

I have no access to the admin page for the production environment RS, however I am responsible for fixing issues with reports being scheduled in that environment.

Currently I am relying on an admin to inform me on any errors in the many subscriptions running in production.

I am looking for a convenient way of monitoring the production environment; am I supposed to ask for both the text file logs and read rights for the RS log tables or I can get relevant info from only one source?

Thanks,
elsvieta

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,069 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
{count} votes

Accepted answer
  1. ZoeHui-MSFT 34,581 Reputation points
    2024-05-28T01:37:05.31+00:00

    Hi @elsvieta

    database tables

    Do you mean that you can access the execution logs in report server database?

    The execution log is a SQL Server view stored in the report server database. The report server execution log contains data about specific reports. The data includes when a report was run, who ran it, where it was delivered, and which rendering format was used.

    The service trace log contains detailed information that is useful if you're debugging an application or investigating an issue or event.

    For better maintenance of the report server, you should ask for both the text file logs and read rights for the RS log.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful