I can't seem to get a handle on this events table. The SQL you supplied isn't working on my server (4.1.3.0 on AIX). When I do a select with no dates in the where clause, all I get is the admin scheds for the current day. Other than that, I can't get a thing. Is there something I'm missing??
Thanks Guillaume Gilbert CGI Canada Zlatko Krastev/ACIT <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 2002-06-07 08:54:26 Veuillez r�pondre � "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Envoy� par : "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Pour : [EMAIL PROTECTED] cc : Objet : Re: Select statement (using events table) select schedule_name, status, result, reason - from events - where date(scheduled_start) <= current_date - cast(1 as interval day) Zlatko Krastev IT Consultant Please respond to <[EMAIL PROTECTED]> To: "'Zlatko Krastev/ACIT'" <[EMAIL PROTECTED]> cc: Subject: RE: Select statement (using events table) Hi Zlatko, So that's the trick... I've trying to get the startdate set, using some example statements, but I cannot get it done it seems. Here's what I tried: select schedule_name,status,result,reason from events where (scheduled_start - 1 day) Well, that doesn't work :-( (obviously because the syntax isn't right :-) ). Do you happen to know how that works? Kind regards, Rick -----Oorspronkelijk bericht----- Van: Zlatko Krastev/ACIT [mailto:[EMAIL PROTECTED]] Verzonden: 6 juni 2002 14:56 Aan: [EMAIL PROTECTED] Onderwerp: Re: Select statement (using events table) Rick, the trick is that Tivoli decided for some reasons select from events to be limited as is in Q EVENT. You need to specify WHERE clause. Zlatko Krastev IT Consultant Please respond to [EMAIL PROTECTED] Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Select statement Hi *SMers, I've trying to figure something out using select-statements. I want to know what events did or didn't complete succesfully for, say, the last 24 hours. I'm getting the results, but I only get the results since last midnight. How do I get the results from the last 24 hours. This is what I have so far: select schedule_name,scheduled_start,actual_start,result from events Anyone here who can help? Kind regards, Rick Harderwijk Systems Administrator Factotum Media BV Oosterengweg 44 1212 CN Hilversum P.O. Box 335 1200 AH Hilversum The Netherlands Tel: +31-35-6881166 Fax: +31-35-6881199 E: [EMAIL PROTECTED]
