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!
One Reply to “SSRS Report History – keep more than 60 days”
Thanks for the share! Very useful info, looking to communicate!
Webmaster of elliptical machine reviews