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

Since the upgrade to OLV we are facing a lot of issues, i am not able to fetch a simple report for all the traps received in last 1 day to the OLV(Orion Log Viewer).

All the help will be greatly appreciated,

Top Replies

Seashore 17 days ago +1 verified

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…

+1 Seashore 17 days ago

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())
Cancel
Up +1 Down

Reply

Reject Answer

Cancel
0 faizan_123 17 days ago in reply to Seashore

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

Reply

Verify Answer

Cancel