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
|