JR,
What would be wrong with just doing :
q eve * * begindd=-7 ennd=today exceptionsonly=yes
Unless your question is just an SQL concern I think this will give you just what you are looking for!
-- Regards, Mark D. Rodriguez President MDR Consulting, Inc.
=============================================================================== MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE ===============================================================================
JR Trimark wrote:
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
