Accessing SSRS log programmatically?

Question

We have several SSRS reports. We call the SSRS execution web-service's Render method and pass the name of the report and the parameters which we want to execute. This method(report) internally executes MDX query returns us the ByteArray which we convert into JSON and pass to another application. All this is working fine. **Why are we following approach**: We already have around 100 reports and we just want to use its output instead of creating new application which will execute MDX query using ADOMD and return us data. **Problem:** If there is any error/exception during execution, I want to access the stack trace and the logs. Is there any way to get this information while executing the report or after execution is over?

Answer 1

Yes, it is possible to access SSRS logs programmatically using the ReportingServicesLog class in the Microsoft.ReportingServices.Diagnostics namespace.

You can add a reference to the Microsoft.ReportingServices.Diagnostics.dll assembly in your project and use the following code to access the SSRS logs:

using Microsoft.ReportingServices.Diagnostics;

// Create a ReportingServicesLog instance

ReportingServicesLog log = new ReportingServicesLog();

// Set the log level (optional)

log.CurrentLogLevel = LogLevel.Verbose;

// Get the log entries for a specific time period

DateTime startTime = DateTime.Now.AddDays(-1);

DateTime endTime = DateTime.Now;

LogEntryCollection entries = log.ReadLog(startTime, endTime);

// Iterate over the log entries

foreach (LogEntry entry in entries)

{

// Do something with the log entry

}

The above code will retrieve log entries for the last day with a verbose level of logging. You can adjust the log level and time period according to your requirements.

Note that you may need to have appropriate permissions to access the SSRS logs.