Unable to add multiple table poller value in Email alert.

rajasekar

I have enabled for one Custom table poller value but in mail I need to add other table poller assigned to that node.

In Below query am trying to add the Sub query in insert variable in that one nested query added. If the execute query working fine in SWQL studio but in email query is not fetching any value instead of the getting the full query in mail.

Node : ${N=SwisEntity;M=CustomPollerAssignment.Node.Caption}
Tunnel Status : Down
More Details : ${N=SWQL;M=SELECT N.CustomPollerAssignment.CustomPollerName AS Metric, N.Status
FROM Orion.NPM.CustomPollerStatusOnNode N
INNER JOIN Orion.Nodes C ON C.NodeID = N.NodeID
WHERE C.Caption = ${N=SwisEntity;M=CustomPollerAssignment.Node.Caption} AND N.RowID = (
   SELECT N.RowID
   FROM Orion.NPM.CustomPollerStatusOnNode N
   INNER JOIN Orion.Nodes C ON C.NodeID = N.NodeID
   WHERE C.Caption=${N=SwisEntity;M=CustomPollerAssignment.Node.Caption} AND N.CustomPollerAssignment.CustomPollerName = 'Severity' AND N.Status ='4')
}

Severity is the poller I have added in UNDP. Anyone help or please suggest if I need to modify above query.

rajasekar

I got the solution for this question.