[SAM] variables in SQL Server User Experience Monitor Query

rsdom

Hi,

I created a SAM Application with a SQL Server User Experience Monitor.

For test purposes I tested this component with a simple SQL Query that returns the Status of a node.

Inside the query I want to use the caption of the node for the where clause. If I use a variable the component can't be tested successfully.

Can variables used for SQL Queries in this component?

Working:

SELECT [Status]
FROM Nodes
WHERE Caption = 'example_hostname'

Not Working:

SELECT [Status]
FROM Nodes
WHERE Caption = '${N=SwisEntity;M=Application.Node.Caption}'

SELECT [Status]
FROM Nodes
WHERE Caption = '${Node.Caption}'

SELECT [Status]
FROM Nodes
WHERE Caption = '${Caption}'

christopher.t.jones123

try ${NodeName}