Hi guys,
Hopefully this is something that has been seen before. I've been asked to come up with an alert notification for Wireless Controllers that will send the information about connected access points as part of the email notification that is set as one of the trigger actions. In SQL, I came up with the following query that will do it for me:
select dbo.Wireless_AccessPoints.name from dbo.wireless_AccessPoints
INNER JOIN dbo.Wireless_Controllers
ON dbo.Wireless_AccessPoints.NodeID=dbo.Wireless_Controllers.NodeID
In the alert notification, I've added a WHERE line, to specify the NodeID, and that then allows the query to output the correct associated access points:
${SQL: select dbo.Wireless_AccessPoints.name from dbo.wireless_AccessPoints
INNER JOIN dbo.Wireless_Controllers
ON dbo.Wireless_AccessPoints.NodeID=dbo.Wireless_Controllers.NodeID
Where dbo.Wireless_Controllers.NodeID=${N=SwisEntity;M=NodeID}
}
When I simulate the trigger, rather than the full list of APs, I'm only getting the first one, but when I re-run the same query in SQL (specifying the same NodeID), I get the full list. Also, if the node does not have any associated APs, the query text is shown, rather than the AP information, which in this instance should return nothing at all.
Am I missing something here? Have I created a monster by combing a SQL query with a SWQL variable?
