We monitor our customer environments and as such there is no consistency in the assignment of hostnames. In fact, we find the same hostnames used between different customer environments in some cases and usually their hostnames don't include anything that identifies which customer the node belongs to. As such we have created a syntax for node names we use in Orion.
My team is very good about ensuring they are on the right customer system before performing work. Especially work that could affect users in those environments. One of the things they have asked me to do, which I believe is very valid, is to include the IP Address of the related node in Alert Notifications. This is possible today in some cases because the ${IP_Address} variable is available but it is not when it comes to Component based monitors.
Both ${NodeName} and ${NodeId} are available under "APM:Component" "Variable Category" but not ${IP_Address}. I would like to see the ability to use ${IP_Address} added so that it can be used as a cross-reference in ensuring that the team is working with the correct node.
BTW: Although this request is related to SAM, I have placed it in the NPM forum since the location where this is used is within Advanced Alert Manager which is part of NPM. Hopefully this is the right approach.
UPDATE... I did not realize that you could use an SQL query within a variable. That will be very helpful. Guess this feature request would therefore not be needed.