I have a working SQL query that is used in a report, it reports on established BGP neighbours, filtered by AS.
This is useful to see what provider each of my routers is peering with.
I'd like to have this in a modern dashboard, but not able to convert to SWQL.
Can anyone help convert please?
select DISTINCT Nodes.Caption, NeighborIP, NPM_RoutingProtocol.DisplayName, NPM_RoutingProtocolStateMapping.DisplayName, NPM_VRFs.Name from dbo.NPM_RoutingNeighbor
Inner join dbo.Nodes ON dbo.Nodes.NodeID = dbo.NPM_RoutingNeighbor.NodeID
Inner join NPM_RoutingProtocol ON dbo.NPM_RoutingProtocol.ProtocolID = dbo.NPM_RoutingNeighbor.ProtocolID
Inner join NPM_RoutingProtocolStateMapping ON dbo.NPM_RoutingProtocolStateMapping.ProtocolStatus = dbo.NPM_RoutingNeighbor.ProtocolStatus
Inner join NPM_RoutingTable ON NPM_RoutingTable.NodeID = NPM_RoutingNeighbor.NodeID
Inner join NPM_VRFs ON NPM_RoutingTable.VrfIndex = NPM_VRFs.VrfIndex
where NPM_RoutingProtocolStateMapping.DisplayName like 'Esta%'
and NPM_RoutingTable.VrfIndex not like ''
and NPM_VRFs.Name not like 'Mgmt-int%'
and AutonomousSystem = 3356
