what does this query give you? any kind of error, or just empty set (no data)?
I get an error.
It says: "Column SysLog.IP is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."
If I take out all but COUNT(SysLog.Message) AS Message from the select statment the qurey returns a digit representing the total number if messages containing the words 'down' and 'serial'.
I'm looking for an output which shows each node name and next to it the total number of times a serial interface has gone down on that node.