IP SLA capable nodes are missing from the list of available nodes in VNQM

10/19/2018 8:53 PM

5/28/2020 6:23 PM

Some IP SLA capable nodes do not appear in the list of available nodes when trying to add an IP SLA node to VNQM. The OID required to recognize a node as IP SLA capable is present: 1.3.6.1.4.1.9.9.42.1.1.1.0
No relevant errors are logged.

VoIP & Network Quality Manager

Nodes that you had already imported to VNQM either by using the IP SLA node discovery wizard, or by adding them manually are not displayed in the list of available nodes.

If a node was renamed or its IP address changed, the database may still contain the outdated node information when the list of nodes is updated.

To resolve this issue, use the following SQL statement to refresh the VoipSites database table:

-- 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.

UPDATE VoipSites
SET IPAddress = Nodes.IP_Address,
  Name = Nodes.Caption
FROM Nodes
WHERE VoipSites.NodeID = Nodes.NodeID