• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

setting for logs in SSRS

what is the pattern in which log files are written? i see sporadic times in which the log is written.. is there a setting for it?

thanks
log.jpg
0
anushahanna
Asked:
anushahanna
  • 7
  • 5
1 Solution
 
HumpdyCommented:
MSDN:
http://msdn.microsoft.com/en-us/library/ms159110.aspx

Configuration Settings for the Report Server Execution Log

You can turn report execution logging on or off by selecting options in Report Manager on the Site Settings page or on the Server Properties page in Management Studio.

By default, log entries are kept 60 days. Entries that exceed this date are removed at 2:00 A.M. every day. On a mature installation, only 60 days of information will be available at any given time.

The report execution log is stored in the report server database. You cannot set limits on the number of rows or on the type of entries that are logged. However, you can create reports that retrieve the log information you want to track.
0
 
anushahannaAuthor Commented:
Humpdy, there are 2 log folders
1)C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\ExecutionLog (this is the msdn link is referring, right?)
and
2)C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles (this is the screen shot i had posted)

>>The report execution log is stored in the report server database.
whi table holds it?
0
 
HumpdyCommented:
hi,

It's a view, in the reportserver database.

WS_ExecutionLog
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
anushahannaAuthor Commented:
thanks -

in the 2 logs i mentioned, is the first one for every report executed, and the next for every other activity in the report server?
0
 
HumpdyCommented:
You got it Sir.
0
 
anushahannaAuthor Commented:
would i check in the ReportServer DB?

I could not find such an object...
select * from sysobjects where name like '%log%' -- Looking for WS_ExecutionLog
0
 
HumpdyCommented:
Yes,
if you do

use database ReportServerDB (Or whatever your reportserver is called)
select * from WS_ExecutionLog
0
 
HumpdyCommented:
use ReportServerDB
select * from WS_ExecutionLog
0
 
anushahannaAuthor Commented:
thanks -

I ran

use reportserver
select * from WS_ExecutionLog

and got ..

Msg 208, Level 16, State 1, Line 1
Invalid object name 'WS_ExecutionLog'.
0
 
HumpdyCommented:
you're using SSRS 2000 I understand, from one of your previous posts ?
table may just be called
select * from ExecutionLog
0
 
anushahannaAuthor Commented:
excellent- thanks very much, friend..

0
 
HumpdyCommented:
cool, glad it worked.
now we just need to fix your other problem !
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now