Display ESX Host IP address in Alert

FormerMember

I just created and enabled a new alert to trigger when a virtual machine state changes (poweredOn/poweredOff). The format of the alert message is...

     VM host ${DisplayName} on ESX host ${HostNodeName} ${Node.IP_Address} is ${GuestState} ${DateTime}

When the alert is triggered the variable ${Node.IP_Address) is not substituted with the ESX host address.

     VM host bwipano004 on ESX host maabwiesx2 ${Node.IP_Address} is poweredOff Monday, March 21, 2011 10:10 AM

Apparently, ${Node.IP_Address} variable doesn't work for ESX nodes.  Likewise, there doesn't seem to be a variable reference for the VM host IP address either.  

Do variables exist to display the ESX host and VM host IP address in an alert message?

qle

I just created a test alert and ${Node.IP_Address} worked for me. Keep in mind that it actually returns the IP address of the VM/guest, not the host itself. Is it safe to assume that Type of Property to Monitor is set to Virtual Machine?

Anyway, if you still can't get  the ${Node.IP_Address} variable to work for you, here are a couple of SQL queries that may help.

The following returns the VM/guest IP address:

${SQL:select IPAddress From VIM_VirtualMachines where VirtualMachineID=${VMID}}

The following returns the host IP address:

${SQL:Select IPAddress From VIM_Hosts where NodeID=${HostNodeID}}

Please let me know how this works out for you.