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
Store

Widget to display historical values of UnDP

I've gone through what I believe to be all widgets that contain the term "Universal device poller", and none of them give me what I want.

To start, I created a undp to retrieve an OID related to the device serial number. The purpose is to see if a pair of active/passive devices that share a virtual IP are flipping back and forth.

The Universal Device Poller Status widget shows the latest polled value and the time it was polled.

What I'm looking for is to show every time it polled and the value. For example, something like this:

Date/Time - SN

00:00 - abcd

00:01 - abcd

00:02 - abcd

00:03 - wxyz

00:04 - wxyz

00:05 - abcd

etc.

I was able to source the SQL for this query, but I can't seem to find a widget that can display a custom SQL query - only a custom SWQL query. Am I wrong?

So I created a report to display this, and was looking for a widget to display the report, but I could not figure that out either.

Appreciate any suggestions on how to get this data displayed on my node details/summary page. Thanks

Find more posts tagged with

Widgets

universal device poller

Accepted answers

ahawkins72

Generally, when I do this, I use a Custom Table widget and change the data source to Custom.

If you're on a more recent version, uncheck Use current network object if it's checked, then edit datasource.

Change selection method to advanced database query and you can select either SWQL or SQL.

You'll then have to add the columns in under the table layout. Fun fact, if you expand advanced under the individual columns and check to enable HTML tagging, you can embed HTML into your SQL query (I use it to change text size, color, and add hyperlinks for instance)

Hope this helps!

All comments

ahawkins72

Generally, when I do this, I use a Custom Table widget and change the data source to Custom.

If you're on a more recent version, uncheck Use current network object if it's checked, then edit datasource.

Change selection method to advanced database query and you can select either SWQL or SQL.

Hope this helps!

ahawkins72

Oh! Also, the web data source picker query is a little more finnicky than just running a SQL query against the database in SSMS. One issue I have run into frequently is that I can run a query perfectly in SSMS, but it fails in the Data source picker. If this happens, check OrionWeb.log for something more verbose than "Invalid query." Frequently, this is because of an implicit deny select permission on the particular table you are referencing. If you go to the table properties and look under the Permissions tab, you will see something like dbo and scroll down to "select". It will have the Deny box checked. Officially, I will NOT tell you to uncheck that and make your custom table query work (until the next config wizard, at least). ;)

Lofstrand

There is a difference between SQL and SWQL. I would recommend that you use SWQL - SolarWinds Query Language. That does not work in SSMS, instead you can download the free SWQL Studio here : https://github.com/solarwinds/OrionSDK/releases

ahawkins72

I use either, depending on what I'm actually trying to do. I've run into issues trying to get certain functions to work properly with SWQL, but that could just be me. The OP said he was trying to use SQL though, so just posting one of the road blocks I've run into before!

rickas27

Yes, this helps! Thanks!