SSRS Report History – keep more than 60 days

Many may know that the following query can get information about the history of reports being called.

What i didn’t realize until today that the above query pulls out of tables which are (by default) limited to the last 60 days.  So, what if you want more history than just 60 days?  Well, turns out there’s a table you can query as in:

select * from ConfigurationInfo

Furthermore, with the following update statement you can extend the history of your Server:

UPDATE ConfigurationInfo SET Value = ‘365’ WHERE Name = ‘ExecutionLogDaysKept’

That’s all there is to it!

Leave a Reply

Your email address will not be published. Required fields are marked *