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:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of Rainer Tammer
> Sent: 07 November 2006 09:15
> To: ADSM-L AT VM.MARIST DOT 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