SWQL Query Parameters/Variables (e.g. DECLARE @VarName TYPE = 'value')

tgerbert

In standard SQL I sometimes "DECLARE @Variable VARCHAR = 'some constant value'" so I can use "@Variable" in various places throughout the remainder of the query, instead of writing out "some constant value" every time - it makes the code a bit easier to read, and it makes it easier to adjust that constant value in the future if I ever need to.

Is this possible with a SWQL query? (I can't find any documentation on SWQL query parameter syntax.)

m-milligan

You can't do it in SWQL. To use parameters with SWQL, you'll need to use the Solarwinds API to execute a SWQL query. Then, you can pass in the parameterized query and the parameters. For example, in PowerShell you'd do this:

$IP = '127.0.0.1'
$swisQuery = "SELECT NodeID, Caption from Orion.Nodes where IPAddress = \@p"

$nodeDetails = Get-SwisData $SWIS $swisQuery @{p=$IP}