3 Replies Latest reply on Dec 4, 2014 9:30 AM by bwjensen

    Output last 25 syslog messages for node on Advanced Alert email

    jpike
    jpike Aug 14, 2014 10:51 AM

      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!