Which tables contians old event log?

[denny]

Hi,

I check the events table, it only contains today' events log. But which table contains the old even log if you set retension say 10 days. I know we can isue " q event * * begindate=today-N" to get old event log. But there must be somewhere to held the data. Any ideas?



Thanks,

Denny

 

[stanleyb]

There is a bizarre trick you need to do to get that to work.



Instead of



select * from events



make sure you query against the scheduled_start field like this:



select * from events where scheduled_start>'03/01/2006'



or whichever date you want. You need to specify an actual date, it won't work for me if I do >current timestamp - 10 days.

 

[mateinone]

<TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Quote:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><BLOCKQUOTE>

There is a bizarre trick you need to do to get that to work.



Instead of



select * from events



make sure you query against the scheduled_start field like this:



select * from events where scheduled_start>'03/01/2006'



or whichever date you want. You need to specify an actual date, it won't work for me if I do >current timestamp - 10 days.



</BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE>



It will work if you set a previous date and then the current_timestamp -10 days



so



scheduled_start >= 01/01/2001 -

and scheduled_start >= current_timestamp -10 days