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:[EMAIL PROTECTED] (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:[EMAIL PROTECTED] Behalf Of Joni Moyer Sent: Wednesday, March 19, 2003 7:09 AM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] (717)975-8338