Hi All,
You can use the following SWQL query to generate a report which gives you the total number of SNMP traps received by the devices within the last 5 days.
If you are facing a high number trap count to the SolarWinds polling engines, you can use this report to analyze it.
Here is the query you can use:(This only works with LA/OLV)
SELECT n.Caption, n.MachineType, let.Type, ms.IPAddress, COUNT(ms.IPAddress)as trap_count
FROM Orion.OLM.LogEntry AS le
LEFT JOIN Orion.Nodes AS n
ON le.NodeID = n.NodeID
LEFT JOIN Orion.OLM.MessageSources AS ms
ON le.MessageSourceID = ms.MessageSourceID
LEFT JOIN Orion.OLM.LogEntryType AS let
ON let.LogEntryTypeID = le.LogEntryTypeID
Where le.DATETIME>ADDHOUR(-120,GETDATE())
and
let.Type='Traps'
GROUP BY ms.Caption
