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,

Find more posts tagged with

traps

syslog

olv

sql

SWQL

report

Accepted answers

Seashore

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())

All comments

Seashore

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())

faizan_123

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