We are working on integration with SNow, SolarWinds recommended method of integration is to read event logs table as stated in query below.
Since we have done a lot of custom polling (UNDP), we were tying to log each alerts in event table only to find out NetworkNode and NetObjectID are coming out blank against those alerts/nodes, this breaks the integration since NetworkNode and NetObjectID are not expected to be blank. This is something got overlooked in design or being gray areas ?
Query to pull data from SolarWinds Orion
var query = "SELECT TOP " + MAX_EVENTS_TO_FETCH + " EventID, EventTime, NetworkNode, NetObjectID, EventType, Message, Acknowledged, NetObjectType, Timestamp FROM Orion.Events WHERE NetworkNode >= 0 AND NetObjectID > 0";
Ref: Query to pull data from SolarWinds (ServiceNow Community)
We request SolarWinds developer team to add NetworkNode AND NetObjectID against alerts/nodes for all custom polled nodes in event logs.
