Can we add a widget on a particular node using SWQL, or a report that will display current node object

NetDev_sol

Can we create a widget on any node under which i can create table and that will have the output only for that node on which widget is added and will be the same for other nodes as well each node should show its own output.

I have came across custom table widget under which might have the option, but am not sure how or where to create the query that will show the results on this widget 


I have tried creating the report for which columns could be added but unless i uncheck Data source, i  am not getting option to load from source and once i am adding the report i couldn't find this use current network object as data source option, i need the report should show only the concerning node output.

ronan.tonilon

Yes, in SolarWinds, you can display node-specific data using SWQL in a widget or a report, but there are some nuances depending on where and how you're trying to show it.

Option 1: SWQL Widget on a Node Details Page

You can add a “Custom Query” widget (SWQL widget) to a node details view, and it will automatically filter to the current node using ${NodeID} as a variable.

 Steps:

1. Go to Settings > All Settings > Manage Views.

2. Choose the “Node Details” view you want to edit.

3. Click “Customize”.

4. Add a “Custom Query” widget (or "Custom Table" if you want column formatting).

5. Paste your SWQL query like this:

<span><span class="hljs-keyword">SELECT<br /></span>&nbsp; N.NodeID, <br />&nbsp; N.Caption <span class="hljs-keyword">AS</span> [Device Name],<br />&nbsp; N.IPAddress, N.Status,<br />&nbsp; CP.Status <span class="hljs-keyword">AS</span> [Custom Poller <span class="hljs-keyword">Value</span>]<br /><span class="hljs-keyword">FROM</span> Orion.Nodes <span class="hljs-keyword">AS</span> N<br /><span class="hljs-keyword">LEFT</span> <span class="hljs-keyword">JOIN</span> Orion.NPM.CustomPollerStatusOnNode <span class="hljs-keyword">AS</span> CP <span class="hljs-keyword">ON</span> N.NodeID <span class="hljs-operator">=</span> CP.NodeID<br /><span class="hljs-keyword">WHERE</span> N.NodeID <span class="hljs-operator">=</span> ${NodeID}</span>

<br /><strong>NOTE: ${NodeID}</strong> is a built-in macro that automatically uses the ID of the node being viewed.

Option 2: Node-Specific Report

You can also create a report that dynamically filters for the current node using the web-based report builder:

 Steps:

1. Go to Reports > Manage Reports > Create New Report.

2. Use a Custom Table.

3. In the object type, choose Nodes or any related entity.

4. Use filters like:

   • Node Caption = ${Caption}

   • or NodeID = ${NodeID} (if calling from a node view or drill-down)

This method is useful if you want to export or schedule reports per node.

Key Items:

• Use ${NodeID} only when placing the widget on a node-specific view.

• If you're placing it on a summary view (not node-specific), you’ll need to hard-code a node ID or make it dynamic via dropdown filters (requires more setup).

Example Use Cases:

Use Case	Recommended Approach
Show chassis temperature for this node only	SWQL widget on Node Details page using ${NodeID}
Create a PDF report per node	Report with ${NodeID} filter or scheduled by node
Display multiple metrics (CPU, memory, temp)	Custom Table widget or multiple Custom Query widgets

Conclusion:

Yes, you can use SWQL widgets or reports to display data specific to the current node. Use ${NodeID} inside widgets added to node views to dynamically scope the data to that node.

Hope this helps.