Hardware Details Variables in Email Alerts, don't appear to be valid

FormerMember

I am using the out-of-box notification Alert me when any hardware component goes into a warning or critical state as we want to begin monitoring the hardware. Here is the message details -

Subject - ${SensorDisplayName} on ${NodeName} is ${SensorOrionStatusDescription}

Message -

The ${CategoryName},  ${SensorDisplayName} on ${NodeName} has a current status of ${SensorOrionStatusDescription}.

Device Details:

Manufacturer: ${SQL:Select Manufacturer from APM_HardwareAlertData where NodeId = ${NodeId}}

Model Number: ${SQL:Select Model from APM_HardwareAlertData where NodeId = ${NodeId}}

Serial Number: ${SQL:Select ServiceTag from APM_HardwareAlertData where NodeId = ${NodeId}}Har

For more information click the following link.

    ${APM:HardwareSensorDetailsURL}

I have a device as you can see below that has a warning on a physical disk.

When I test this out-of-box alert against this node this is what I am returned -

Subject - The Power Supply, PS 1 Status on DV-AGVSRV02 has a current status of Up.
Message - 

Device Details:

Manufacturer: Dell Inc.
Model Number: PowerEdge R710

Serial Number: ******* (Taken off for obvious reasons)

Can anyone explain why I am getting these results? I would expect to see something related to the physical disk here. Any help/thoughts is greatly appreciated.

aLTeReGo

You may be encountering a known issue that has already been resolved, but requires you to delete the alert and re-run the configuration wizard to repair. This is outlined in the following KB article.

SolarWinds Knowledge Base :: Incorrect data is appearing in a hardware alert email.