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: [EMAIL PROTECTED] -----Original Message----- From: David Stabler [mailto:[EMAIL PROTECTED]] Sent: 04 September 2002 22:12 To: [EMAIL PROTECTED] 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
