Solved

SSRS Execution Log

Posted on 2014-11-06
10
441 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

708 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

15 Experts available now in Live!

Get 1:1 Help Now