ojoj ✭✭✭

Many thanks for the above! Worked great, I've tweaked a bit too.

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!

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" ..........

Hi. Does anyone know the variable for the group name? I have a share on the server called "photos" and each folder within that is called the site name e.g. \\servername\photos\site1\001.jpg "site1" is the same name as a group in Solarwinds. When I try and display the image using custom HTML I need the variable for group…