I still can't get this to work. Could someone please provide a WORKING
example of a select command that would display all events for the last 10 days?

At 09:37 AM 9/5/2002 +0200, you wrote:

Hi david,

We have encountered the same problem but this can be overcome. What we have
set up is an (asp) server that shows us all the data you need for managing
your TSM server in a webpage.
The trick is that the datestamps you use in your select have to be explicit!
and leave out the "uncertain" backups.

So what we do is issue a select with a date of a few months ago and get rid
of the uncertain status.

met vriendelijke groeten, regards et salutations,
Finn Leijnse

Central Data Storage Management
Shell Services International bv.
dokter van zeelandstraat 1
2265 BD Leidschendam
email: Finn.Leijnse AT shell DOT com
-----Original Message-----
From: David Stabler [mailto:dstabler AT MORRISONHOMES DOT COM]
Sent: 04 September 2002 22:12
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

Money is not the root of all evil - full backups are.