Where is trap data for ${Message} stored in the database?

byrona

On a few of my trap alerts I am using the ${Message} variable which sends me over data via email that I am unable to locate any where in the Orion database; I have looked in both the Trap and TrapVarbinds table but am still unable to find all of the data that I receive via email with that variable.

Specifically, in the email I see the word "Summary:" followed by a bunch of data related to the specific trap/event which I am unable to find in the database.

Any pointers here will be greatly appreciated, thanks!

netlogix

The data from that gets stored in TrapVarbinds, you can get it with this

SELECT TOP 1000 *
  FROM [Traps]
    inner join TrapVarbinds on TrapVarbinds.TrapID = Traps.TrapID
  where IPAddress in ('x.x.x.x','y.y.y.y')