70-466 · Question #83
You need to identify the reports that produce the errors that Marc is receiving. What should you do?
The correct answer is C. Write a query by using the ExecutionLog3 view in the report server database.. Identifying which specific SSRS reports produce errors requires querying the ExecutionLog3 view, which stores structured per-execution records including status and error details for every report run.
Question
Options
- AWrite a query by using the Subscriptions table in the report server database.
- BUse the Windows Event Viewer to search the Application log for errors.
- CWrite a query by using the ExecutionLog3 view in the report server database.
- DSearch the ReportServerService_<timestamp>.log file for errors.
How the community answered
(69 responses)- A4% (3)
- B7% (5)
- C87% (60)
- D1% (1)
Why each option
Identifying which specific SSRS reports produce errors requires querying the ExecutionLog3 view, which stores structured per-execution records including status and error details for every report run.
The Subscriptions table stores subscription definitions and delivery configuration metadata, not runtime execution outcomes or error details, so it cannot identify which reports produced errors during execution.
Windows Event Viewer captures system-level and application-level events but does not record individual SSRS report execution results with enough granularity to map errors back to specific report names.
The ExecutionLog3 view in the report server database records one row per report execution and includes columns for report name, user, execution status, error messages, and parameters. Filtering this view by user and error status pinpoints exactly which reports are failing for Marc without manual log parsing.
The ReportServerService trace log records internal service-level diagnostics and exceptions but is a flat text file - it does not provide a structured, queryable mapping of errors to specific report names and users.
Concept tested: Querying SSRS ExecutionLog3 view to identify report errors
Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view
Topics
Community Discussion
No community discussion yet for this question.