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