Hello,

One of my daily checks is the select-query below:
select DATE_TIME,NODENAME,MESSAGE from ACTLOG WHERE MSGNO=4959 and
date_time>timestamp(concat('$1',' 07:00'))

The problem is that the output is msgno 4959 for all nodes. I only want to
see the nodes with 1 or more objects failed. When there are no objects
failed, I don't want to see the output for that node, because it is 'ok'.

I've tried a lot but so far no results. Can anyone give me a hint?

With regards,

Brian


_________________________________________________________________
Download MSN Explorer gratis van http://explorer.msn.nl/intl.asp