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.

NPM 11.5: Alertstatus.notes

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