Ken:

Select * from events only shows events for the current day.

See http://msgs.adsm.org/cgi-bin/get/adsm0009/619.html for an explanation.

Tim Rushforth
City of Winnipeg

To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  select * from events - only today's events


Am I missing something?

I have Eventretention set to 90 days.  I can use "query event" to see event
data from days past.

But if I use "select * from events" I only get events from today, no
historical data.

Shouldn't the Events table have previous days results in it?

Thanks... Ken