Sadly, the events info (via "q events") is a consolidation of several tables, 
including internal info not externalized; I understand that IBM is working to 
resolve this so we can "select" query such info.  

For now, you must use the "q ev" command (with modifiers) to easily get this 
info;  in your example, "q ev * * HM*" (HMCH* and HMPG* using two commands).

One way of pulling out a simpler time expression...
        time(date_time)>'16:00:00'
so, maybe(?), 
        time(scheduled_start)>'16:00:00' 
(else, play with other SQL modifiers -- see Paul's presentation from SHARE -- 
and post your examples).  

HTH!


Don France
Technical Architect -- Tivoli Certified Consultant
Tivoli Storage Manager, WinNT/2K, AIX/Unix, OS/390
San Jose, Ca
(408) 257-3037
mailto:don_france AT ayett DOT net (change aye to a for replies)

Professional Association of Contract Employees 
(P.A.C.E. -- www.pacepros.com)



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Joni Moyer
Sent: Wednesday, March 19, 2003 7:09 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: select statement


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