Solved

SSRS Execution Log

Posted on 2014-11-06
10
445 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
  • 5
  • 5
10 Comments
 
LVL 12

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 12

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
 
LVL 12

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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 12

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 12

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
GRANT, REVOKE, DENY 4 36
SQL Server - Check Constraint or NOT NULL? 11 67
Linking a DMV to a database id/sql text in SQL server 2008 8 45
TSQL DateADD update Question 4 25
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Backup & Restore 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.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

932 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now