Server Properties (Logging Page)

Use this page to set limits on the report execution data that is collected by a report server. Execution data is stored internally in the report server database. You can track report activity for report server that runs in native mode or SharePoint integrated mode. If the report server is part of a scale-out deployment, the report execution log maintains a record of all report activity for the entire deployment in a single log file.

To access the log data that is stored internally, Reporting Services provides sample reports, packages, and instructions for viewing report execution log data. For more information, see Querying and Reporting on Report Execution Log Data.

To open this page, start SQL Server Management Studio, connect to a report server, right-click the report server name, and select Properties. Click Logging to open this page.

Options

  • Enable report execution logging
    Click to create and store information about report activity on the server. If this option is enabled, the report server will track which reports are used, the frequency of report processing, the type of report operation that was performed, the output format, and who ran the report. For more information about additional data points that are captured in the log, see Report Server Execution Log.

  • Remove log entries older than this number of days
    Specify the number of days after which log entries will be trimmed from the report execution log. The default value is 60 days.