Hi,

how can i code a select statement, which gives me all nodename related
events from the actlog and the last hour?

The "current-time-1" is not the right statement.

select servername,nodename,date_time from actlog where
date_time='current-time-1'

mfg / regards

andreas rensch / rz-qs
tel : +49(0)6171 66 3692 / fax : +49(0)6171 66 7500 3692 / mobil : +49(0)172
6649 016 / mailto:renscha AT alte-leipziger DOT de
Alte Leipziger Lebensversicherung aG - Alte Leipziger Platz 1 - D 61440
Oberursel - http://www.alte-leipziger.de

> Christmas is weird. It's the only time of year when we love to sit in
> front of a dead tree and eat candy out of our socks.
>