Ahh, I see. I knew that TSM tables were built 'on the fly'; but had't realised that the events table is essentially unbounded, hence the need for the 'special' behaviour.
Thanks, Matt. > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Henrik Wahlstedt > Sent: 07 November 2006 11:01 > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] select events table > > Nope, see the explanation in 'Why does it Work that Way (Andy > Raibeck).pdf' from TSM Symposoium in Oxford 2005. > > "Events table is calculated at runtime..." etc > > Cheers > Henrik > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of > Matthew Warren > Sent: den 7 november 2006 11:37 > To: ADSM-L@VM.MARIST.EDU > Subject: Re: select events table > > Odd, how can it be that select * from events returns > different to select > * from events where scheduled_start>'1900-01-01' How is the table > 'special'? > > > > Matt. > > -----Original Message----- > > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf > > Of Rainer Tammer > > Sent: 07 November 2006 09:15 > > To: ADSM-L@VM.MARIST.EDU > > Subject: Re: [ADSM-L] select events table > > > > Hello, > > > > goc wrote: > > > hi, > > > when i make select * from events i get data only for > current date , > > > i know with q event you can get back as defined in server options > > > but i would like to make some count(*) and stuff on > events data, so > > > my question is can i get further in past with direct > > select statement > > > to events table ? > > > > > This is a special table. > > You need a SELECT similar to the following statement: > > > > select count(*) as \"Administrative Schedules Successful\" > from events > > > where LENGTH(domain_name) IS NULL and scheduled_start > > '1900-01-01' > > and scheduled_start between (current_timestamp - 24 hours) and > > current_timestamp and status='Completed' and result=0 > > > > The important part is the scheduled_start > '1900-01-01' . > > Without the boundary you will get no useful events. > > > > > thanks big time > > > > > > goran > > > > > > > > Bye > > Rainer Tammer > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ----------------------------------- > > > 3.3TB in 12hours > > > > > > > > > > > > > > > > > This email is confidential and may be privileged. If you are not the > intended recipient please notify the sender immediately and delete the > email from your computer. > > You should not copy the email, use it for any purpose or disclose its > contents to any other person. > Please note that any views or opinions presented in this email may be > personal to the author and do not necessarily represent the views or > opinions of Digica. > It is the responsibility of the recipient to check this email for the > presence of viruses. Digica accepts no liability for any damage caused > by any virus transmitted by this email. > > UK: Phoenix House, Colliers Way, Nottingham, NG8 6AT UK > Reception Tel: + > 44 (0) 115 977 1177 Support Centre: 0845 607 7070 > Fax: + 44 (0) 115 977 7000 > http://www.digica.com > > SOUTH AFRICA: Building 3, Parc du Cap, Mispel Road, Bellville, 7535, > South Africa > Tel: + 27 (0) 21 957 4900 > Fax: + 27 (0) 21 948 3135 > http://www.digica.com > > > ------------------------------------------------------------------- > The information contained in this message may be CONFIDENTIAL and is > intended for the addressee only. Any unauthorised use, > dissemination of the > information or copying of this message is prohibited. If you > are not the > addressee, please notify the sender immediately by return > e-mail and delete > this message. > Thank you. > > > >
