Advanced alerts and SQL statements

thurgoodj187

I would like to include recent syslog and events in my email events that are sent.  For instance, when cpu utilization is high, I would like to see the last 10 syslog messages from that server in the email that is sent. Here is my logic:

Node Information:  

Node: ${Node.Caption}
IP Address:  ${Node.IP_Address}
Node Type:  ${Node.MachineType}

Memory Utilization:  ${Node.PercentMemoryUsed}
Response Time:  ${Node.ResponseTime}

Alert Infromation
Alert Trigger time: ${AlertTriggerTime}
Count:  ${AlertTriggerCount}
Acknowledged:  ${Acknowledged}
Acknowledged By:  ${AcknowledgedBy}
acknowledged On:  ${AcknowledgedTime}

Recent logs: 

${SQL:Select Top 25 * From SysLog where IP = '${Node.IP_Address}' and (DATETIME > (GETDATE()   - 7)) }

This does not seem to work, is anyone doing this? 

njoylif

try it without the getdate() section and see if that piece works, then work on the issue from there, if it does.

Actually, do you need the getdate if you are just pulling the top 25?  I haven't looked at that table.