On May 22, 2007, at 3:11 AM, Stefan Holzwarth wrote:
"and nodename in (select nodename from nodes where
domain_name='MAC') "
^^^^^^^
That should instead be: NODE_NAME
Note well the unfortunate field name variations across tables.
2) since the original query above works with date strings I have to
substitute that part with something like that being using in q actlog
begind=-24:00 ...
I think you mean begint=-24:00
The Select prototype would be:
SELECT * From ACTLOG where -
CAST((CURRENT_TIMESTAMP-DATE_TIME) HOURS AS INTEGER) < 24
Richard Sims
|