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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Matthew Warren
Sent: den 7 november 2006 11:37
To: ADSM-L AT VM.MARIST DOT 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: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


-------------------------------------------------------------------
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.