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