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

Using page NodeID in Custom Query

Hi,

I have a custom query that translates API Poller values back in to text.

SELECT  str.text, vtm.displayname, ap.DisplayName as DisplayName, ap.Node.NodeID
FROM Orion.APIPoller.ValueToMonitor vtm
JOIN Orion.APIPoller.StringToNumberTransformationRule str ON vtm.id = str.valuetomonitorid
JOIN Orion.APIPoller.ApiPoller ap on ap.ID = vtm.ApiPollerId
Where ap.Node.NodeID = ${NodeID}

The query works fine in SWQL Studio when the last line ${NodeID} is replaced with a number. What I want to do is have it display for the node on the current page. Having searched around the query should work as is but all I get is the message 'There was an error processing the request.'

Find more posts tagged with

Accepted answers

All comments

adam.beedell

Tested this partway in my environment. - Do you get an error when line 5 is removed?

MattPeters

Figured it out, the error was actually not related to the NodeID but was in the first line. SWQL Studio now errors on 'alias [DisplayName] already defined. All strange seeing as it worked last week (except the NodeID part).

So now I have this, which works

SELECT  str.text, vtm.displayname, ap.DisplayName, ap.Node.NodeID
FROM Orion.APIPoller.ValueToMonitor vtm
JOIN Orion.APIPoller.StringToNumberTransformationRule str ON vtm.id = str.valuetomonitorid
JOIN Orion.APIPoller.ApiPoller ap on ap.ID = vtm.ApiPollerId
Where ap.Node.NodeID = ${NodeID}

yaquaholic

Try

SELECT str.text, vtm.displayname AS VTM-DisplayName, ap.DisplayName, ap.Node.NodeID