Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

setting for logs in SSRS

Posted on 2010-11-08
12
Medium Priority
?
346 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
[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
  • 7
  • 5
12 Comments
 
LVL 10

Accepted Solution

by:
Humpdy earned 2000 total points
ID: 34090997
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
ID: 34091591
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
ID: 34091601
hi,

It's a view, in the reportserver database.

WS_ExecutionLog
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

 
LVL 6

Author Comment

by:anushahanna
ID: 34091655
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
ID: 34091661
You got it Sir.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093047
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
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093064
Yes,
if you do

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

Expert Comment

by:Humpdy
ID: 34093069
use ReportServerDB
select * from WS_ExecutionLog
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093089
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
ID: 34093096
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
ID: 34093153
excellent- thanks very much, friend..

0
 
LVL 10

Expert Comment

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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

604 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