ADSM-L

Re: select * from events - only today's events

2001-11-22 05:42:19
Subject: Re: select * from events - only today's events
From: Remco Post <r.post AT SARA DOT NL>
Date: Thu, 22 Nov 2001 10:37:19 +0100
> Am I missing something?
>
> I have Eventretention set to 90 days.  I can use "query event" to see event
> data from days past.
>
> But if I use "select * from events" I only get events from today, no
> historical data.
>
> Shouldn't the Events table have previous days results in it?
>
> Thanks... Ken
>
Nope, the people at tivoli did however. At least, it 'works as designed' but
they decided that 'select * from events' should return the same as 'q event',
eg. only todays data. I heard they actually put quite some time into hacking
this select to do exactly that that none of use really want it to do...


--
Met vriendelijke groeten,
Met vriendelijke groeten,

Remco Post

SARA - Stichting Academisch Rekencentrum Amsterdam
High Performance Computing  Tel. +31 20 592 8008    Fax. +31 20 668 3167

"I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end." -- Douglas Adams