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
joni.moyer AT highmark DOT com
(717)975-8338