Andy, Thank you very much for your help, the results are exactly what I was looking for.
Andrew Raibeck <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 02/28/2005 04:06 PM Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] cc Subject Re: [ADSM-L] SQL statement help See http://msgs.adsm.org/cgi-bin/get/adsm0501/349/1.html for a suggested workaround. Refer to APARs IC28825 and IC34609 (at http://www.ibm.com) for more info describing limitations of querying the EVENTS table. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[email protected]> wrote on 2005-02-28 14:40:48: > The following command returns those backups that were missed or failed: > > select node_name,contact from nodes - > where node_name in (select node_name from events where - > (scheduled_start between '2005-01-31 15:39:26' and - > '2005-02-27 15:39:25') and - > LENGTH(domain_name) IS NOT NULL and - > (status='Failed' OR status='Missed')) > > I have modified the sql select statement for the last week and nothing is > returned. > select node_name,contact from nodes - > where node_name in - > (select node_name from events where - > (scheduled_start>=current_timestamp - 7 days) and - > LENGTH(domain_name) IS NOT NULL and - > (status='Failed' OR status='Missed')) > > OR > > select node_name,contact from nodes - > where node_name in - > (select node_name from events where - > (substr(cast(scheduled_start as char(26)),1,19) between '2005-01-31 > 15:39:26' and - > substr(cast(current_timestamp as char(26)),1,19) and - > LENGTH(domain_name) IS NOT NULL and - > (status='Failed' OR status='Missed'))) > > Any ideas on why the 2nd/3rd sql statement does not return anything? > > > thanks > JR
