Routing Neighbors Alert

damiancbessemer

The information presented in the Dashboard is perfect.

Am I missing something? Why is the alert on that very same information so poor?

Ideally, the email alert should report exactly what the dashboard does, again, which is perfect.

Find more posts tagged with

network_monitoring

network_management

Alerts

Accepted answers

All comments

JiriPsota

Hi,

Can you give me a use case? What alert are you not able to build with current properties.

Thanks

damiancbessemer

Thanks for responding.

On the dashboard, under 'Network', within the 'Network' subtab is a section called 'Routing Neighbors'. The information is helpful, and we would like an alert containing this information.

Node Name Protocol Status IP Address

Thanks again.

JiriPsota

Try to use this in your Trigger Action Message:

Node Name: ${SQL:SELECT NodeName=CASE (SELECT COUNT(*) FROM Nodes WHERE IP_Address='${NeighborIP}')

WHEN 0 THEN '${NeighborIP}'

ELSE (SELECT DISTINCT Caption FROM Nodes WHERE IP_Address='${NeighborIP}')

END}

Protocol: ${SQL:SELECT DisplayName FROM NPM_RoutingProtocol WHERE ProtocolID=${ProtocolID} AND IP_Version = (SELECT IP_Version FROM NPM_RoutingNeighbor WHERE NeighborID=${NeighborID})}

Status: ${DisplayName}

IPAddress: ${NeighborIP}

damiancbessemer

Thanks for the offering.

I tried this script, but I have questions about the results.

Please see the generated email below:

Node Name: ${SQL:SELECT NodeName=CASE (SELECT COUNT(*) FROM Nodes WHERE IP_Address='$@NeighborIP@'
WHEN 0 THEN '$@NeighborIP@';
ELSE (SELECT DISTINCT Caption FROM Nodes WHERE IP_Address='$@NeighborIP@'
END}
Protocol: OSPF
Status: Full
IPAddress: 10.x.x.x

I really like the Protocol, Status and IP Address information supplied, but can't really do much what precedes. Where do I modify to make it work?

Thanks again,