How to restrict an SQL Report to current Node ${NodeID}

Question

Hi,

NPM 12.4.  I created an SQL Report Writer report for some UnDP pollers. I want to inset this report into Node Details Summary view.

Question-1: How to limit the report to the Current Node in that View ?  Filtering by ${NodeID} was reject by SQL query in my report.

Question-2: is there a way to Edit the Out-of-the-Box Widgets / Dashlets provided in the SolarWinds Orion Default Views ?

Than you

xaturbatu · Accepted Answer

You want to use SWQL which is the one who understands ${nodeid} instead of SQL. You can put custom query on the node details after converting the query and it will work as expected or just use a custom table if you find the details you need on custom universal poller table and you won't need to use a query.