This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Output last 25 syslog messages for node on Advanced Alert email

I'd like to include the last 25 syslog messages for a node on an advanced alert email but I'm not too confident or familiar with SQL or how to execute this.

Would someone be able to give some guidance? Or is this not possible in the advanced alerting system for NPM 11.0?

The little I've figured out so far for Syslogs ...

  • Within Advanced Alerts I can "Define SQL Variable" which I believe is where this can be done
  • I want to select the last 25 records from [dbo].[SysLog] table
  • Included fields: DateTime, IP, Message
  • To display the relevant device I believe the following needs to be done, IP=${IP_Address}

Thank you for the help!