List nodes down in a group and sub groups in an e-mail alert

I have the following group structure:

Site Name
-- Site Name WAN
-- Site Name LAN

In the Site Name group, I have a number of custom properties.

If the “Site Name” group is in warning/down state, I’d like an e-mail alert to let me know what nodes in all the sub-groups are down.

What is the best way to achieve this please!? – Many thanks!

My e-mail template at the moment looks like:

Hi all,

 

The following alert has been triggered by Solarwinds on ${N=Alerting;M=AlertTriggerTime;F=DateTime}.

 

Site Name: ${N=SwisEntity;M=Name}

Site Classification: ${N=SwisEntity;M=CustomProperties.Site_Classification}

 

The following networks are used on this site:

 

Network Name 1: ${N=SwisEntity;M=CustomProperties.Network1;F=TrueFalse}

Network Name 2: ${N=SwisEntity;M=CustomProperties.Network2;F=TrueFalse}

 Network Name 3: ${N=SwisEntity;M=CustomProperties.Network3;F=TrueFalse}

 Network Name 4 ${N=SwisEntity;M=CustomProperties.Network4;F=TrueFalse}

 Network Name 5 ${N=SwisEntity;M=CustomProperties.Network5;F=TrueFalse}

 

The following node(s) are currently down in this group:

 

<<<INSERT NEW CODE HERE!!!>>>>

Find more posts tagged with

Accepted answers

Lofstrand

Everything in the first box is the "variable".

So the part that starts with ${SQL:... , add that to wherever you want that information to be.

The second picture is an example of how it looks like if you add the variable in the alert

Like this:

All comments

Lofstrand

Hi @ojoj

How about using the variable "Group Stautus Root Cause", ${N=OrionGroup;M=GroupStatusRootCause}.

That will give you a list of all group members that is "causing" the group status.

ojoj

Hi Lofstrand - that did work yes thank you!

Is there a way to list the nodes within the "causing group" that have issues?

e.g.

"Group Status Root Cause", Site XYZ LAN is Warning.

"Nodes in that group with issues are" ..........

Lofstrand

There doesn't seem to be any prebuilt, but we can always build one ourselves with "Custom variables". Here we write our own SWQL or SQL code to get the data we want.

The issue here is that a variable can't include several rows. So a normal query would here give us one row per member and that's not allowed. We need to merge the lines into one line, I do that with "FOR XMP PATH". Then the code looks like this:

${SQL: 
SELECT(
SELECT 
	C.name	+ ' (' + S.ShortDescription + '), '
FROM ContainerMemberSnapshots AS C
INNER JOIN NodesData as N ON C.EntityID=N.NodeID AND C.Entitytype='Orion.Nodes'
INNER JOIN StatusInfo AS S ON N.Status=S.StatusId
WHERE 
	C.ContainerID=${N=SwisEntity;M=ContainerID} 
ORDER BY C.Name
FOR XML PATH ('')
) AS T}

Then in alert action it can look like this:

(I haven't teste the query in an alert but it should work....) Tested now, it didn't work.... So I have updated the code AND tested. Should work now ;-)

This only list direct members in that group, and not other member types than nodes. So if you have subgroups or other entity types the query need some additional work.

ojoj

Many thanks!

Excuse my ignorance!! - Where do I add the SQL code from the 1st box above? and does the code from the 2nd box go in the email alert? - as this is an image, would you be able to copy the text please?

Many thanks again!