need ms sql query to list latest status of dynamic protocol neighbor
1=up
2=down
enjoy
SELECT TOP (1000) [NeighborID]
,[NodeID]
,[NeighborIdentifier]
,[NeighborIPGUID]
,[NeighborIP]
,[ProtocolID]
,[ProtocolStatus]
,[IP_Address_Type]
,[IsDeleted]
,[IP_Version]
,[LastChange]
,[AutonomousSystem]
FROM ['mydatabase'].[dbo].[NPM_RoutingNeighbor]
thank you
era sure your welcome. mark as helpful\resolved or something, need the points.
my final query that gives me what i need:
use SolarWindsOrion;
SELECT
n.NodeID,
n.SysName,
NeighborIP,
m.ProtocolID,
rn.ProtocolStatus,
n.NextPoll,
rpsm.DisplayName,
rpsm.OrionStatus
FROM NPM_RoutingNeighbor rn
LEFT JOIN NPM_RoutingProtocolStateMapping rpsm
ON rn.ProtocolID=rpsm.ProtocolID
AND rn.ProtocolStatus=rpsm.ProtocolStatus
LEFT JOIN Nodes n
ON rn.NodeID=n.NodeID
