Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SSRS Execution Log

Posted on 2014-11-06
10
Medium Priority
?
529 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 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
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Loops Section Overview
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

580 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