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