I get nothing, as in ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11.
I don't get it... I should have all the shceduled backups for yesterday. I've tried and tried to come up with a SQL query that would enable me to format the ouput of a q ev * * the way I want it (without long node names wrapping) but nothing seems to work... Guillaume Gilbert CGI Canada Zlatko Krastev/ACIT <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 2002-06-07 10:58:30 Veuillez r�pondre � "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Envoy� par : "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Pour : [EMAIL PROTECTED] cc : Objet : Re: R�f. : Re: Select statement (using events table) Why it does not work? What error is returned and if it complains for syntax at which word? To be sure it works I've tested it on TSM 3.7.0 for Win (being at customer site) but when I return to office I will test it on 4.1.4.1 for AIX (out test one) and on 4.2.1.15. Zlatko Krastev IT Consultant Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: R�f. : Re: Select statement (using events table) 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]
