Hello, I am trying to do a select statement that queries events for only the client backup schedules. I received the following command from a fellow user:
select node_name , scheduled_start , schedule_name , status from events I tried to customize this command and I am receiving no output when I know that there is. Is there any suggestions? Here is what I am trying to do: I want to select all nodes that begin with HMCH* and HMPG* for the past day. I tried the following command and received no results. Is my syntax wrong? Thanks!!! select node_name, scheduled_start, schedule_name, status from events where node_name like 'HMCH%,HMPG%' and scheduled_start > current_timestamp - 1 day order by node_name Also, is there any way to shorten the current_timestamp to get rid of the ssssss? Thanks again! Joni Moyer Systems Programmer [EMAIL PROTECTED] (717)975-8338
