Solved

setting for logs in SSRS

Posted on 2010-11-08
12
337 Views
Last Modified: 2012-05-10
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
Comment
Question by:anushahanna
  • 7
  • 5
12 Comments
 
LVL 10

Accepted Solution

by:
Humpdy earned 500 total points
Comment Utility
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
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
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
 
LVL 10

Expert Comment

by:Humpdy
Comment Utility
hi,

It's a view, in the reportserver database.

WS_ExecutionLog
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
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
 
LVL 10

Expert Comment

by:Humpdy
Comment Utility
You got it Sir.
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 10

Expert Comment

by:Humpdy
Comment Utility
Yes,
if you do

use database ReportServerDB (Or whatever your reportserver is called)
select * from WS_ExecutionLog
0
 
LVL 10

Expert Comment

by:Humpdy
Comment Utility
use ReportServerDB
select * from WS_ExecutionLog
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
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
 
LVL 10

Expert Comment

by:Humpdy
Comment Utility
you're using SSRS 2000 I understand, from one of your previous posts ?
table may just be called
select * from ExecutionLog
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
excellent- thanks very much, friend..

0
 
LVL 10

Expert Comment

by:Humpdy
Comment Utility
cool, glad it worked.
now we just need to fix your other problem !
0

Featured Post

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

Join & Write a Comment

Suggested Solutions

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
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…

772 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

10 Experts available now in Live!

Get 1:1 Help Now