Hops/nodes quantity in NetPath.

Question

I want to create an alert related to a path changing in NetPath. Has anybody tried to it? Is it possible to do it based on the number of nodes/hopes (I haven't found any fields related to it in NetPath Endpoint Service/NetPath Endpoint Service on Probe objects)?

alexch · Answer

Yes, I know about this table but there are no explicit path values there.

mesverrum · Answer

The way netpath traces show up in the database is relatively complex so I haven't taken the time to try and  break it all down.  The simplest indicator would probably to watch for changes to the Orion.NetPath.Tests table in swql, there are a lot of values there that seem like they could give you info on path changes.

SELECT ExecutedAt, EndpointServiceID, ProbeID, ProbeStatus, CompletionRatio, UniqueEdgeCount, UniquePathCount, TotalTraceCount, TotalEdgeCount, PortClosedTraceCount, DestUnreachedTraceCount, DnsFailureTraceCount, RouteChangeCount, EdgeChangeCount, SentPackets, LostPackets, ConnectionBased, Rtt, RttMin, PacketLoss, Status, Graph

FROM