Greetings,
Has anyone come up with either a formatting formula in LogParser, or some other method to easily parse and ingest the Reporting Server trace log files?
For whatever reason, the SSRS developers have chosen to not put the error messages for report execution into the appropriately named ExecutionLog table. Instead the information is only available either with Remote Errors turned on (Security issue), or by reading through the Trace files.
I have a need to ingest these trace files for researching and resolving errors, doing so manually is not an option as I have a scale-out environment with 3 nodes and thousands of users an hour - it's impossible to keep up with the files manually.