SSRS Log for reports run, length and statistics

  • Hi,

    What is the precess to keep these information stored. Info like how long the report took to execure, homany times, so on.

    Please inform me!!

  • Use ReportServer

    SELECT TOP 10 * FROM dbo.ExecutionLog

    That should give you what you're looking for.

  • For historical reporting you should take a look at downloading the Report Execution Log Files sample from the Microsoft Samples on CodePlex and they have some reports you can use to review the data - Server Management Report Samples.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply