Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Help with Custom Table for SNMP using Dynamic Query

I've got a custom table in my node detail view that is looking at some specific custom SNMP pollers. How do I build a dynamic query to look at just the specific pollers I want in that table for the current object? My problem is that if I use the default object selection, I can't pick which pollers I want to use for that table. If I use a dynamic query to look for the specific pollers I want, I can't figure out a way to tell it to just use the current object.

In other words, I want to build a table that lists the name and current values for a handful of custom pollers based on the current object (so I don't have to manually pick the data source for every new object).

Thanks.

Find more posts tagged with

SNMP

dynamic query

custom table

Accepted answers

All comments

tony.johnson

If the pollers were created as UNDPs there are options as to where you want to display these on the console.

https://thwack.solarwinds.com/t5/NPM-Discussions/UnDP-Web-Display-Question/td-p/157141

https://support.solarwinds.com/SuccessCenter/s/article/Create-a-Universal-Device-Poller-UnDP

You can also use macros within the queries when used on an entity view such as:

SQL: SELECT Caption FROM Nodes where NodeId= ${NodeID}

SWQL: SELECT Caption FROM Orion.Nodes where NodeId= ${NodeID}

PNA_Kahn

Thank you. That got me part of the way there. Wound up with this query:

SELECT
CustomPollerLabels.Label,
CustomPollerAssignmentView.CustomPollerName,
CustomPollerAssignmentView.CurrentValue
FROM
CustomPollerAssignmentView
INNER JOIN CustomPollerLabels ON CustomPollerAssignmentView.CustomPollerAssignmentID = CustomPollerLabels.CustomPollerAssignmentID
WHERE
NodeID=${NodeID}
AND
(
CustomPollerName LIKE '%DSRC_Channel_Num%'
OR
CustomPollerName LIKE '%DSRC_Channel_Mode%'
)

But now I'm getting this:

For reference, on another node using a static selection, here's what I'm getting:

These are both custom table widgets.

Here's what the manual selection looks like: