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.
