This content has been marked as final.
Show 3 replies
-
Re: Output last 25 syslog messages for node on Advanced Alert email
HolyGuacamole Aug 14, 2014 11:15 PM (in response to jpike)Try this
${SQL:SELECT TOP 25 Message_UNICODE + ' | ' as 'data()' FROM [dbo].[SysLog] WHERE NodeID=${NodeID} FOR XML PATH ('')}
-
Re: Output last 25 syslog messages for node on Advanced Alert email
jpike Aug 15, 2014 2:08 PM (in response to HolyGuacamole)Yes! This was exactly what I was looking for!
I didn't think that I would need to separate lines! Off the the googles to see how to make each record show up on a new line!
Thank you so much!
-
Re: Output last 25 syslog messages for node on Advanced Alert email
bwjensen Dec 4, 2014 9:30 AM (in response to jpike)${SQL:SELECT TOP 25 Message_UNICODE + CHAR(13) + CHAR(10) as 'data()' FROM [dbo].[SysLog] WHERE NodeID=${NodeID} FOR XML PATH ('')}
-
-