Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Advanced Alerts utilizing groups and alert reminder

PSAV2011

I've just upgraded to Orion NPM 10.1.2 SP1, and what I'm trying to do is the following:

1) I have created groups for each of my locations with two sub groups:

a) 1 sub-group is for my WAN device and the other is for my LAN devices

2) I've created a dependency for my two sub groups: LAN(child) is dependent on the WAN (parent)

What I'm trying to accomplish is the following:

- if my WAN device is unreachable, do not alert me on the LAN devices.

- An alert e-mail reminder (every X amount of minutes) sent to my team when the WAN device is down only (not for the LAN devices)

anyone else successful in setting this up? Any input/suggestions would be appreciated!

Find more posts tagged with

Accepted answers

All comments

netlogix

Your first one should be done once the dependencies are setup right and the alert is for status is down.

The second could be setup by having an separate second alert for the WAN devices that is delayed, say 60 minutes, then repeats every 60 minutes. Make the second alert an advanced SQL node alert and add in:

where (
interfaces.Status = 2
) AND (
    Nodes.Caption in (Select ContainerMemberSnapshots.Name
      from ContainerMemberSnapshots
        inner join Containers on Containers.ContainerID = ContainerMemberSnapshots.ContainerID
      where Containers.Name like '% Switches' and not Containers.Name like '% User Switches'
)

The % is a wild card *.* would be %.% for the sql 'like' command. Or, if you have one group name, the second where could be changed to "where Containers.Name = 'MPLS Routers'"

PSAV2011

Is there anyway to accomplish this without using the Advanced SQL Queries? I was hoping to be able to tie them into Advanced Alerts somehow, and adjust the conditions/etc there?

Thanks again for your response!

netlogix

That was also my first question when I was able to start using groups, but I was told that it was not available at this time. I hope it is added to their list of things to do, but I don't know if it was for sure.