Node Name(Caption) or NodeID as variables or arguments in SQL User Experience Monitor

Forgive me if I have failed to find the answer elsewhere, but I'm curious as to whether or not node name or nodeID are accessible from within a SQL User Experience Monitor.
If not, I could resort to wrapping the SQL in PowerShell because I know I have access to those node attributes as variables within a PowerShell monitor, but it would be nice to not have to do so.
If it can be done, would the variables be usable as-is within the SQL? or would I have to create argument statements to use them?

much appreciation to any and all help or suggestions with this

Find more posts tagged with

sql variable

node id

sql query*

Accepted answers

mesverrum

I know if you use ${ip_address} it resolves to the ip address of the node the application/component is on, so I would expect that it should work the same was for ${nodeid} or ${caption}

All comments

mesverrum

I know if you use ${ip_address} it resolves to the ip address of the node the application/component is on, so I would expect that it should work the same was for ${nodeid} or ${caption}