Consolidate "Alert me when a neighbor goes down" to single alert with neighbor status

jmorgan0407

Is there a way to consolidate the alerts for "Alert me when a neighbor goes down?"  Currently I get alerted for each adjacency.  For example:

1st e-mail alert:  RTR1 has lost adjacency with RTR9

2nd e-mail alert: RTR2 has lost adjacency with RTR9

3rd e-mail alert: RTR3 has lost adjacency with RTR9

4th e-mail alert: RTR4 has lost adjacency with RTR9

and so on.

Id like to get alert like this:

Following Routers lost adjacency with RTR9:

     RTR1, RTR2, RTR3, RTR4, etc...

RichardLetts

You would have to flip the alert around and make the 'subject' of the alert on RTR9, and then concarenate strings using a custom SQL variable.

basically, you will need to chunks of SQL, one to return RTR9's nodeid if its peeting is down on /other/ routers

and another to return a comma-separated list of  routers whose peerings with RTR9 are down

http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string