I have read through most of the previous posts on the forums and have still not been able to make this work. It seems like others are having this problem so I am hoping someone has found a workaround. I am trying to use some variables in my alert e-mail message and I am having some trouble. Specifically, I am triggering the alert when disk utilization is over 85%. Ideally, the setup would be as follows
Alert: Disk ${VolumeName} on ${NodeName} is over 85%
The problem is that when I specify the alert to monitor disk utilization (alert applies to volumes instead of nodes) I can not seem to grab the node name using any macro. ${NodeName} gives me a long form of the Volume caption and I have tried using a SQL variable.
${SQL:Select Caption from Nodes where NodeID=${NodeID}} - Doesn't work!
${SQL:Select Caption from Nodes where NodeID=54} - Works!
${NodeID} - Works! (Returns 54)
I also have a custom property to this node which I cannot seem to access without hardcoding the Node ID in the SQL statement (as above). This obviously wont work becuase my alert applies to more than one node. Anyone else have similar problems or found a workaround?