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: [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 Money is not the root of all evil - full backups are.
