Post reply

Enter your state hereIncrease available report history

  • January 23, 2014 at 1:28 pm

    #282726

    I ran queries against the view [ReportServer].[dbo].[ExecutionLog3] on SQL Server 2012 and was surprised to see only two months of report history is available.

    Where can I increase the number of history records we have? I'd like to save a year of history.

    Thank you -

  • January 24, 2014 at 2:16 am

    #1683032

    You can change the value for ExecutionLogDaysKept in the ConfigurationInfo table of the ReportServer DB.

    Edit: Should probably add, you can get to this by connecting to Reporting Services through SMSS under Properties -> Advanced if you dont want to update the table.

    Alternatively you could look at something like SCRUBS (http://scrubs.codeplex.com/) to warehouse off you execution logs.

  • January 24, 2014 at 9:16 am

    #1683178

    Great ! Thank you.

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

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