How To List of Network Down Nodes in Single Email

Question

Now I am able to get Network Down Alert for Single Node Separate Email for Each Node. Guide Me How to Get All the List of Down Nodes in Single Email.

adam.beedell · Answer

You probably want to cut that list down a bit rather than just all. Draws false connections. An example similar macro is here: Other downs in the last 15 minutes ${SQL: SELECT Caption+Char(9)+Char(10) FROM Nodes WHERE Vendor in ('Windows', 'Linux', 'net-snmp') AND Status like '2' AND ISServer like '1' AND DATEDIFF(minute, Nodes.LastSystemUpTimePollUTC, GETUTCDATE()) <= 15 AND Caption not like '${N=SwisEntity;M=Caption}' UNION SELECT ' ' AS Caption For XML path('') }

FormerMember · Answer

This is where you need a down nodes report sending out in the email. So create your down nodes report and simply attach it to your email and send it out on a schedule say once a day.