SSRS report usage metrics for last 2 years but I could see last 60 days logs

Question

Need to capture SSRS report usage metrics for last 2 years but ExecutionLog I could see last 60 days logs.

Can you please someone help me the configuration change for it ?

Answer 1

Hi @Prabu, Chandran ,
By default, log entries are kept 60 days. Entries that exceed this date are removed at 2:00 A.M. every day. On a mature installation, only 60 days of information will be available at any given time.

You cannot set limits on the number of rows or on the type of entries that are logged.

See more: Configuration Settings for a Native Mode Report Server.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Copy frequently the result of view ExecutionLog3 to a user defined table to archive the data for a longer period.