Comments
-
Thank you so much for this! I used this to pull a list of volumes on a server into an alert email! ${SQL: SELECT Caption+', ' From Volumes Where NodeID = ${N=SwisEntity;M=Node.NodeID} FOR XML PATH ('') } Never would have figured out how to pull in this info without your post.
-
Even after getting the above SQL to validate, when I tried to test the alert by changing the last two lines of query to: AND Nodes.CPULoad >= 0 AND CustomPollerStatus.Rate >= 0 the Summary tab of the test always showed that 0 nodes would fire the alert. I opened a ticket with SW Support and after a great suggestion from…
-
When implementing this alert validation of the query kept failing. After comparing to the Windows counterpart I changed the last line of the query to: AND CustomPollerStatus.Rate >= c2.CPUCount Validation passed after this change.