Where to find report server execution log

Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. It seems like Sql Reporting Services Server logs information in several places including web server logs and logging tables in the database. Where are all the locations SSRS logs to, and what type of errors are logged in each place? The database is typically the most easily available one.

You just login to the ReportServer database and execute. This only logs the executions though. If you want more information you can go to the Trace Log files, which are usually available at location may of course vary :. If you're searching for an error you can go to the Windows Application Log Under Administrative Tools in your control panel.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Skip Submit. The execution log is a SQL Server view stored in the report server database. The report server execution log contains data about specific reports, including when a report was run, who ran it, where it was delivered, and which rendering format was used. Report Server Service Trace Log. The service trace log contains very detailed information that is useful if you are debugging an application or investigating an issue or event.

Windows Application Log. That is very good to know, and I totally neglected it. Turns out I only had 3 months of data. Good work, what about Power BI reports. Thank you Steve. Really appreciate your work. One of the query helped me identify the reports using by particular source with their last run time.

Can you help me with Admin day-to-day log activities like, if user got deleted by some one who has admin permissions and how to track those info. Your email address will not be published. Time limit is exhausted.

I hope you enjoy the Database Health Monitor. Let me know if you have any questions. This log contains a wealth of information including exceptions that were generated, background processing review, and logs of operations completed by the Report Manager and web service.

In addition to the default trace log, the SSRS http trace log provides details about the SSRS web services receipt of requests and it's subsequent response to those requests.

Both of these logs allow for customizing specific settings via the ReportingServicesService. Related Articles. Report launcher to run SSRS report subscriptions on demand. EXE Utility. EXE command line video. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data.

How to tell what SQL Server versions you are running. Ways to compare and find differences for SQL Server tables and data. Resolving could not open a connection to SQL Server errors.

Searching and finding a string value in all columns in a SQL Server table. View all my tips.