2 Replies Latest reply on May 4, 2015 5:01 PM by RichardLetts

    NPM 11.5: Alertstatus.notes

    RichardLetts

      Anyone know where the alertstatus.notes field ended up in the database.

       

      I've spent 30 minutes looking around the tables, and it's not obvious to me where they got moved to:

       

      Here is the SQL query I used to have in a report:

       

      SELECT n.sector, -- custom property

             a.objecttype,

             ad.Alertname,

             a.objectname       device,

             a.triggertimestamp Time,

             a.notes

      FROM   alertstatus A    

             INNER JOIN AlertDefinitions ad

                     ON ad.AlertDefID = a.AlertDefID

             INNER JOIN nodes n

                     ON n.nodeid = a.activeobject

      WHERE  a.objecttype = 'Node' and state=2