Hello,
I have written an application to read events using SWIS API on regular interval(e.g every 30 seconds) and pass it to ticketing system from other vendor.
API Query is :
https://<<SERVERIP>>:<<PORT>>/SolarWinds/InformationService/v3/Json/Query?query=SELECT n.IP_Address, e.Message, e.NetObjectID,n.EntityType, n.Description, n.DetailsUrl, n.Caption, n.DetailsUrl, e.EventTime,et.Name, e.Message FROM Orion.Events e INNER JOIN Orion.Nodes n ON e.NetworkNode = n.NodeID INNER JOIN Orion.EventTypes et ON e.EventType = et.EventType WHERE et.EventType NOT IN (506,504,11,519,529,524) and e.EventTime>='2019-05-27 18:30:00'
Note: I am using Orion.Events.EventTime in where condition to get only differential events.
Issue : The number events is very less compare to the below query executed in SWQL. I have tried many times and there is difference in all the time
SELECT n.IP_Address, e.Message, e.NetObjectID,n.EntityType, n.Description, n.DetailsUrl, n.Caption, n.DetailsUrl, e.EventTime,et.Name, e.Message FROM Orion.Events e INNER JOIN Orion.Nodes n ON e.NetworkNode = n.NodeID INNER JOIN Orion.EventTypes et ON e.EventType = et.EventType WHERE et.EventType NOT IN (506,504,11,519,529,524) and e.EventTime>='2019-05-27 18:30:00'
Support Expected: How to ensure that my application does not miss any events generated in SolarWinds