Need SQL/SWQL query for a report about Traps received in last 1 day in the OLV

Hi, Update SWQL studio to at least 3.0, then you can play around with Orion.OLM.

This simple SWQL query gives you a start:

SELECT TOP 1000
L.LogEntryID,
N.Caption,
L.DateTime,
L.Message,
L.Uri
FROM Orion.OLM.LogEntry AS L
INNER JOIN Orion.Nodes AS N ON L.Nodeid=N.Nodeid
Where L.DATETIME>ADDHOUR(-24,GETDATE())

Thanks for your help, i will update the Studio and go forward from there.