I'm creating a custom query resource that shows to flapping routes. It works great, but now I'm trying to hyperlink the node captions. That's not working. What am I doing wrong?
The line in bold red is the one that makes the query fail. How do I do this?
Here's the code:
Note2: I don't think comments work in SWQL. Argh!
==============================================
SELECT TOP 100
f.Router.Nodes.Caption AS [Node],
/* f.Router.Nodes.DetailsUrl AS [_LinkFor_Node], -- Where Node is the label given for the Caption*/
f.Router.Nodes.IP_Address AS [Address],
f.RouteDestination AS [Route],
Count(f.FlapId) AS [Flaps]
FROM
Orion.Routing.RoutingTableFlap f
WHERE
f.Router.Nodes.CustomProperties.Layer = 'WAN' AND
f.Router.Nodes.UnManaged = 0 AND
(f.Router.Nodes.CustomProperties.CircuitType <> 'EVDO' OR
f.Router.Nodes.CustomProperties.CircuitType <> 'LTE') AND
DayDiff(f.DateTime, GetDate()) < 1
/* Looking at flaps for the last 1 day */
GROUP BY
f.Router.Nodes.Caption, f.Router.Nodes.IP_Address, f.RouteDestination
HAVING Count(f.FlapId) > 2
/* Use this to limit display to minimum number of flaps */
ORDER BY
Flaps DESC
