Display UnDP "SNMP GET TABLE" as a Table

Hi, I'm looking for help to build a table widget using modern dashboards to monitor IP SLA. Trying to achieve this using UnDP as there is no VNQM module in our setup.

SNMP OID used is "latest RTT operation completion time" - 1.3.6.1.4.1.9.9.42.1.2.10.1.1

Is it possible to display below results from 2 to 3 different nodes as a table widget? Appreciate if someone can help with the details please.

Desired Table Widget Output:

Thank you.

Find more posts tagged with

SNMP

Table Widget

gettable

ipsla

Modern Dashboards

UnDP

cisco

Accepted answers

All comments

stuartd

Nothing to do with your query but can I ask how are you actually extracting the IP SLA details? Are you using the VOIP module or via an OID and an UnDP in NPM.

If the latter, can you detail the approach you've taken please?

sunvad

Using SNMP OID - 1.3.6.1.4.1.9.9.42.1.2.10.1.1. We have multiple IP SLAs configured on the WAN Router; you can see the test result in my original post. I was hoping to display the results as a table widget, but couldn't figure out a way and hence my post.

However, I have added individual IP SLAs as a poller on the node. For example, Row ID 20 (refer to the screenshot in my original post) corresponds to ip sla for Google and Row ID 22 is for Facebook.

In this case, OID will be 1.3.6.1.4.1.9.9.42.1.2.10.1.1.20 (Google) and 1.3.6.1.4.1.9.9.42.1.2.10.1.1.22 (Facebook).

Widget SWQL Query (Ref: from here)

SELECT [Nodes].DisplayName, [Nodes].Status, [Nodes].DetailsUrl
, (SELECT TOP 1 CurrentValue
FROM Orion.NPM.CustomPollerAssignmentOnNode AS n
INNER JOIN Orion.NPM.CustomPollerStatistics AS s ON n.CustomPollerAssignmentID = s.CustomPollerAssignmentID
WHERE n.DisplayName = 'IPSLA_Google' AND [Nodes].NodeID = n.NodeID
) AS Google
, (SELECT TOP 1 CurrentValue
FROM Orion.NPM.CustomPollerAssignmentOnNode AS n
INNER JOIN Orion.NPM.CustomPollerStatistics AS s ON n.CustomPollerAssignmentID = s.CustomPollerAssignmentID
WHERE n.DisplayName = 'IPSLA_Facebook' AND [Nodes].NodeID = n.NodeID
) AS Facebook
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].NodeID = '435' OR [Nodes].NodeID = '571' OR [Nodes].NodeID = '409' OR [Nodes].NodeID = '582'
ORDER BY [Nodes].DisplayName ASC

Hope this helps.

stuartd

Many thanks Sunil - I appreciate the time to write that up.

Sorry that I can't help with your original query though.

sunvad

Definitely helped bump this post