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" <[EMAIL PROTECTED]> on 07/02/2002 02:24:42 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED]