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
