How to create SQL Custom Table to reflect only current viewed Node

Question

I'm trying to pull data about our machines and compare to a SQL table I have an import job run against. This table will populate with our 3rd party warranty status and show whether or not it is covered and other details.  The issue I have is, I can't get a variable to ONLY show the current Node.

This is my code, and the custom table being dbo.SEIWarranty.

SELECT ModelNumber, PartNumber, Description, AdditionalDesc, SerialNumber, Response, Warranty, Location

FROM dbo.SEIWarranty

INNER JOIN dbo.AssetInventory_ServerInformation

on dbo.SEIWarranty.SerialNumber=dbo.AssetInventory_ServerInformation.HardwareSerialNumber

Where NodeID = ????????

AlexSoul · Accepted Answer

You need to create report in Orion Report Writer and then add this report on landing page for the node as a resource "Report from Orion Writer"

SQL filter will look like this:

SELECT

.....

FROM SolarWindsOrion.dbo.Nodes

JOIN ....

WHERE Nodes.Caption = '${Caption}'