nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

NodeID in Web report resources

alxgarder

Hi,

Is there any plan on when ${NodeID} will be supported for the resource Custom Chart and Custom Table?

Currently there is no way to show any form of custom SQL charting per node on a Node Details Page.

Kind regards,

Alx

Find more posts tagged with

Accepted answers

All comments

cjfranca

Into the report writer's on the menu edit the option Show sql and in it you can create the report. any detail

alxgarder

Yeah, sorry, okay.. Maybe I wasn’t really clear here.

I have created a vast SQL lookup that shows information collected by varies Custom pollers (it’s for QOS queues). In order to make this look anywhere nice I have to massage it quite a bit as it combines information from five different MIB tables.

So I got this working, but now I would like to show this as a chart over time, so I can see when I’m dropping packets in the different QOS classes.

My problem comes when I’m trying to integrate this with a Custom Chart Resource on my Nodes Details Page (as I would like to see this for the node I’m currently on). I can add a Chart resource, I can paste in my SQL, but I can’t use ${NodeID} to have the chart only showing information from my particular node as it won’t allow me to use ${NodeID} within my SQL select statement.

I already know that that this is not currently possible as per this information in the help file:

“Note: Web-based reports do not allow the use of variables that are created by preceding a property or database column name with a dollar sign ($) and an open brace ({) and then following it with a close brace (}), as in ${Node.LastBoot}.”

So, back to my question..

Is there any plan on when ${NodeID} will be supported for the resource Custom Chart and Custom Table?

tony.johnson

Hi,

I would also like to see this available as there are some cases where I would prefer to use SQL.

Have you looked at using SWQL as an alternative?

You can download the latest build of the SDK here Orion SDK 2.0 released on GitHub and use SWQL Studio to create your queries. The syntax follows that of normal SQL very closely so the learning curve would be minimal. The custom chart resource will accept SQL or SWQL with SWQL also allowing you to use the NodeID variable

You can also add a custom query resource and use SWQL, as an example try the following on a node details page.

SELECT Caption,Community, Contact, CPULoad, StatusLED, SysName, SysObjectID, SystemUpTime, TotalMemory, Vendor, VendorIcon FROM Orion.Nodes WHERE NOdeId = ${NOdeId}

You can see the custom node pollers under Orion.Npm in SWQL Studio

2016-02-25 14_56_20-SWQL Studio.png

Thanks,

Tony

alxgarder

Hi Tony,

I have just tried your idea and it doesnt work ;(

While the SWQL dialog will allow me to do the "= ${NodeID}" for the statement (no errors) its doesnt actually filter on it. Therefore when I use your SWQL:

SELECT Caption,Community, Contact, CPULoad, StatusLED, SysName, SysObjectID, SystemUpTime, TotalMemory, Vendor, VendorIcon FROM Orion.Nodes WHERE NodeID= ${NodeID}

This will give me a Widget with ALL nodes in it.