If you specify a starting date outside the starting date range, you can retrieve
the entire events table.
I have mine hard coded to 01/01/2001, and it seems to retrieve the entire events
table just fine.

i.e. WHERE (EVENTS.SCHEDULED_START>{ts '2002-01-01 00:00:00'})





"Leijnse, Finn F SITI-ITDSES31" <finn.leijnse AT SHELL DOT COM> on 07/02/2002 
02:24:42
AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Joseph Pendergast/Corona/Watson)

Subject:  ODBC and MS SQL 2000



Hi fellow TSM-ers,

We are trying to make a nice missed and failed backup list available on our
website and have encountered problems with running a SELECT statement of the
events table from the MS SQL server to the TSM server. We have got it
working in EXCEL. EXCEL will run the select on the TSM server and retrieve
the list as requested.
We do not seem to get this proces running for the MS SQL server... Can
anyone help us with this problem?


( The main problem is that when the whole events table is retrieved from a
TSM server only the current day will be fetched and we want to see today and
the previous day! This seems to be a TSM bug that you have to explicitly
state the date in your select query to get the right output from the events
table)

met vriendelijke groeten, regards et salutations,

Finn Leijnse

ITDSES/31 - Central Data Storage Management
Shell International Tech. International
Postbus 1027, 2265 BD Leidschendam
tel: (+31) 703034043
mail: finn.leijnse AT shell DOT com