In the conditions portion specify:

        where date(actual_start)>=date(current_timestamp - 1 days) and
hour(actual_start)>=22 and (timestamp(date(current_timestamp))+8
hours>actual_start)

This should give you the limit you are looking for.  There may be a better
way to skin the cat, but I cannot think of one right now.  I could not test
this on my system because I have nothing in the events table because I use
an external scheduler, but I wrote something similar against the SUMMARY
table and it worked.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: David Stabler [mailto:dstabler AT MORRISONHOMES DOT COM]
Sent: Wednesday, September 04, 2002 4:12 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: DRS: how to select events?


I'm writing a nice little mess that will query the TSM database and produce
pretty reports (custom HTML generation, lots of fun, woo).  My problem comes
from the events listing.  I can ask for events using the query command in
such a way as to generate yesterday-at-10pm to today-at-8am  fairly easily,
but when I try

select [varlist] from events [conditions]

I only see today.  What can I do to get similar output?  The reason is
simple -- if an event "misses", there is no "actual start" field, and my
current filters shift all my variables the wrong way.  Rather than coding
something by column position (doable, but ugly), I'd like to put the
Actual_start field at the end.  Thoughts?

Thanks!

-drs-

David Stabler, CATE/AIX, CNCE
Senior Systems Analyst