Solved

SSRS Execution Log

Posted on 2014-11-06
10
456 Views
Last Modified: 2014-11-11
Hello Guys,

I had a doubt regarding the Executionlogs of SSRS database.
At my workplace, in the SSRS server properties, under Logging, I see that the field
Remove Log entries older than this number of days has been set to 0

I don't understand what does it signifies. Wherever I searched on the Internet I found that the default value is 60 days. Also under the advanced option of SSRS server report properties, the field
ExecutionLogDaysKept is left blank.

Kindly explain this to me.

Thanks and Regards
0
Comment
Question by:Abhinav Singh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 13

Accepted Solution

by:
Koen Van Wielink earned 500 total points
ID: 40427668
The default is indeed 60 days. I've not tried this myself, but my guess is that 1 of 2 things can happen when it's set to 0:
- No history is kept
- All history is kept.

Do you know if this was recently changed? If it's always been set to this setting, check the table "ReportServer.dbo.ExecutionLog" on the reporting server SQL instance. If it contains no records, most likely setting the ExecutionLogDaysKept to nothing means no history is kept. If you do find records, check the TimeStart and TimeEnd columns. If you know for sure the records were created after you've discovered the number of days has been set to 0, you know all history will be kept instead.
0
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 40427670
Just to add, this comes from Microsoft technet:

"ExecutionLogDaysKept: The number of days to keep report execution information in the execution log. Valid values for this property include 0 through 2,147,483,647. If the value is 0 entries are not deleted from the Execution Log table. The default value is 60."

So in your case all history should be kept. Best to check the records anyway as described above to make sure.
0
 

Author Comment

by:Abhinav Singh
ID: 40427673
Hey Koen,

Thanks for your reply.
In the report server database, I see exactly last 60 days records.
Is there anyway to check if the ExecutionLogDaysKept value was altered or changed in the past?
Thanks again
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 40427692
I don't think it's possible to check this. It might be wise to change the value back to what you would like it to be though. It's an administrator setting so normally only admins would be able to touch it. As such I don't think it's worthwhile to create a custom trigger to check for changes to that particular field. Just check periodically if the issue resurfaces. If it does, you can take follow up action.
0
 

Assisted Solution

by:Abhinav Singh
Abhinav Singh earned 0 total points
ID: 40427708
Hey Koen,

Thanks for replying.
I used the following query on the report server database :
SELECT * FROM ConfigurationInfo

Open in new window


In this, the field ExecutionLogDaysKept showed the value 60. But I don't know why everywhere it is either blank or 0. Anyways, this resolved my issue. Thanks for sharing your views.
0
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 40427728
Ok, that's odd. I thought that's the value that's displayed in the field mentioned in your original post.
Anyway, glad to be of assistance.
0
 

Author Comment

by:Abhinav Singh
ID: 40427800
I've requested that this question be closed as follows:

Accepted answer: 0 points for Abhinav Singh's comment #a40427708

for the following reason:

This worked for me and helped me understand my server configuration
0
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 40427801
Can i ask why you request to close the question rather than accept my comments as answer? You asked for clarification on what a 0 value signifies, which was given. I also provided you some ways to check what was exactly happening. I fail to see why the question is not answered.
0
 

Author Comment

by:Abhinav Singh
ID: 40427844
Hey Koen,

Sorry for inconvenience. I'll accept your first post as solution.
Thanks for replying.
0
 

Author Closing Comment

by:Abhinav Singh
ID: 40434606
Both the comments helped equally clear my doubts.
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question