NetObjectId is Null for UNDPN events

By design, the NetObjectId is Null for UNDN events in the Events table.

In the Events table, the issue happens with only one event for NetObjectType=UNDPN:

This does not affect SolarWinds Platform, but affects the ServiceNow integration called: SolarWinds for ITOM Health: SolarWinds Events and ServiceNow Event Management module

As the NetObjectID is NULL for NetObjectType=UNDPN, the ServiceNow integration "SolarWinds for ITOM Health: SolarWinds Events and ServiceNow Event Management module" does not bring in the data event, as their query relies on the NetObjectID column.

This happens because the integration uses the following query to fetch the data: 

SELECT TOP [MAX_EVENTS_TO_FETCH] EventID, EventTime, NetworkNode, NetObjectID, EventType, Message, Acknowledged, NetObjectType, Timestamp FROM Orion.Events WHERE NetworkNode >= 0 AND NetObjectID > 0

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation


SELECT TOP [MAX_EVENTS_TO_FETCH] EventID, EventTime, NetworkNode, NetObjectID, EventType, Message, Acknowledged, NetObjectType, Timestamp FROM Orion.Events WHERE NetworkNode >= 0 AND NetObjectID > 0

The "SolarWinds for ITOM Health: SolarWinds Events and ServiceNow Event Management module" SeviceNow integration was developed and is maintained by ServiceNow. See more details here: ServiceNow and SolarWinds Platform integrations

As a workaround, you can modify the query to something as shown below or directly consult the ServiceNow Technical Support team:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation

SELECT TOP [MAX_EVENTS_TO_FETCH] EventID, EventTime, NetworkNode, NetObjectID, EventType, Message, Acknowledged, NetObjectType, Timestamp FROM Orion.Events WHERE NetworkNode >= 0 AND (NetObjectID > 0 OR NetObjectType = ‘UNDPN’)