?
Solved

SSRS Execution Log

Posted on 2014-11-06
10
Medium Priority
?
478 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 1500 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
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

 
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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

762 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